bigdata - How to compare multiple csv files with millions of records? -

bigdata - How to compare multiple csv files with millions of records? -

i provided 2 sets of csv files in theory should same, reason 1 of sets contains more info other (the csv. files automatic weekly info backups crm system).

ideally, i'd open csv files , vlookup , find missing rows (or "extra" rows)and start investigating come , why discrepancy.

however, these files huge, , contains millions of rows. thought how can compare files , find out how different? applications (hopefully free , easy use) can recommend? i'm not able open files because i'm hitting excel's row limit.

any help appreciated. thanks!

i able resolve using ultraedit , ultracompare. ultracompare's ability compare files amazing. easy use.

bigdata database-migration