Get reference code
Appearance
Sample
List Join

List Join

This online calculator can join two csv lists by key column the same way JOIN works in SQL (inner join, left outer join, right outer join)
Timur2017-10-24 03:35:08

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

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

Second list:
1,Smith
2,Smith

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 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 first list with text from your csv file
  • Set parsing regular expression (note that default regular expression works on row with two columns separated by comma)
  • Set index of key column (this column will be used for join)
  • Repeat the same for second list (note that default regular expression for second list works on 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 joined list with key value in zero column

Lists joinerCreative Commons Attribution/Share-Alike License 3.0 (Unported)
Joined list 

Request a calculator
View all calculators
(514 calculators in total. )

Comments