List Join

I think most of those who ever wrote on SQL know about table joins using the JOIN operator. But what if you have a couple of CSV (comma separated values) lists with key columns containing the same values for both lists and want to get joined list?

For example, like this:
First list:
1,Mister
2,Missis

Second list:
1,Smith
2,Smith

The resulting list, joined by values of zero column in the first list and zero column in the second list:
1,Mister,Smith
2,Missis,Smith

Of course, you can create tables in the database of your choice, import data to the tables, and write your JOIN, or you could write a program on the language of your choice, which will do the same. However, you can also save time and use the calculator below.

Here is how it works:

• Fill the first list with text from your CSV file
• Set parsing regular expression (note that default regular expression works on a row with two columns separated by comma)
• Set index of key column (this column will be used for join)
• Repeat the same for the second list (note that default regular expression for the second list works on a row with two columns separated by space)
• Set join type: inner join, left outer join, or right outer join
• Set column separator for the resulting list
• Set NULL substitution value, of course, for outer joins.
• Click "Calculate"
• You will get the joined list with the key value in the zero column

Lists joiner

1,1.000 2,0.500 3,0.464 4,0.414 5,0.370 6,0.333 7,0.333 8,0.302

First list

Parsing regular expression

Key column index (zero-based)

1 1.000 2 0.500 3 0.646 4 0.686 5 0.685 6 0.666 7 0.777 8 0.732 9 0.689 10 0.687

Second list

Parsing regular expression

Key column index (zero-based)

Join type

Inner join

Left outer join

Right outer join

Joined list column separator

Null substitution (for outer joins)

Show only missing values

Calculate

Joined list

 

 Link  Save  Widget