Hello,
I have about 10 csv files which range from csv1 - csv10.
Each csv file has same type/set of tabs and we have around 5-6 tabs for each of the csv file which have slightly different content(data).
A sample of CSV1 is shown below:
Joins: Data related to Joins, it can be any number of joins depending on the tables
Tables: Banking, Offices
Columns: All column names related to Banking and Office Tables
where Joins, Tables and Columns are different tabs present in the CSV file.
Similarly we have it for all other CSV Files
Now I got to compare csv1 with csv2 and spill out the differences in a Excel file.
Similarly I need to compare csv3 with csv4 and vent out the result in the same Excel file which is our result file.
Similarly for 'n' number of csv files.
Is there anyone who can create an automated script which will do the comparison for 'n' number of csv files at one go and gives the output in an excel sheet.
Your help is really valued and appreciated. Thanks..