Using VLookup like Batch script to compare two excel / csv
Kedar
Using Vlookup: I have two csv files; File1 has Id and Value Columns and File2 has Id. Problem: I need to compare both files and put respective values to File2…
Browsing Tag
compare csv
1 post
2 responses to “Using VLookup like Batch script to compare two excel / csv”
Hi,
I need an help to get the missing records between two csv sheets.
Hello,
I have tried this script to compare csv files, but the output files was not correct. the input file had 36 row and 38 rows each and the output csv have 277 rows. please guide to correct this.
Below is the files I used:-
File1
—–
189208,Tom
918648,Viktor
643297,Sam
File2
—–
189208,London,20130718
918648,Essex,20130807
189208,Berkshire,20130716
918648,Middlesex,20130809
643297,Yorkshire,20130718
Output
——
Tom,London,20130718
Viktor,Essex,20130807
Tom,Berkshire,20130716
Viktor,Middlesex,20130809
Sam,Yorkshire,20130718