Galaxy |

Join (version 9.3+galaxy1)

1st file:

Column to use from 1st file:

2nd File:

Column to use from 2nd file:

Output lines appearing in:

First line is a header line:

Use if first line contains column headers. It will not be sorted.

Ignore case:

Sort and Join key column values regardless of upper/lower case letters.

Value to put in unpaired (empty) fields:

What it does

This tool joins two tabular files based on a common key column.

Example

First file:

Fruit       Color
Apple       red
Banana      yellow
Orange      orange
Melon       green

Second File:

Fruit       Price
Orange      7
Avocado     8
Apple       4
Banana      3

Joining both files, using key column 1 and a header line, will return:

Fruit       Color   Price
Apple       red     4
Avocado     .       8
Banana      yellow  3
Melon       green   .
Orange      orange  7

Input files need not be sorted.
The header line (Fruit Color Price) was joined and kept as first line.
Missing values ( Avocado's color, missing from the first file ) are replaced with a period character.