Join multiple tab-delimited files

Join multiple tab-delimited files

The Join multiple tab-delimited files app is used to merge files progressively into a single data table. Assumptions are made that a) identifier is always column 1 b) identifiers are all present across all data files c) the file is tab delimited with UNIX line endings. Launch the Join multiple tab-delimited files app and pick files in the order you wish them to be joined, left-to-right, and indicate how many lines of header are in the files.

Community rating: ?????

Quick Start

  • To use Join multiple tab-delimited files, your data must be in tab delimited format with the requirements specified above.
  • Resources: This application uses a script drafted by the tool integrator.

Test Data

Test data for this app appears directly in the Discovery Environment in the Data window under Community Data -> iplantcollaborative -> example_data -> join_tab_delimited_files

Please note that the intention of this walk through is to provide an example of how the files will be joined. Scientific use case would be to potentially join files generated by BAM to Counts or to join multiple trait datasets.

Input File(s)

Use a.bed and b.bed from the directory above as test input.

Parameters Used in App

When the app is run in the Discovery Environment, use the following parameters with the above input file(s) to get the output provided in the next section below.

  • Default parameters only, no further configuration needed.

Output File(s)

Expect a text file as output. For the test case, the output file you will find in the example_data directory is named ccombine_results.txt

Tool Source for App