Last Updated: February 25, 2016
·
532
· darkelda

How to join 2 csv like SQL tables

sort -t , -k 2,2 file1.csv > sort1.csv
sort -t , -k 1,1 file2.csv > sort2.csv
join -t , -1 2 -2 1 sort1.csv sort2.csv > sort3.csv