Hello Friends,
I have two files File1.xlsx and File2.xlsx. Each file have 3 different sheets name as "Sheet1" , "Sheet2" and "Sheet3".
My requirement is I have to compare sheets columns between two files where column structure are same in both the files.
This should be work dynamically like workflow will first compare file1.sheet1 with file2.sheet1 , file1.sheet2 with file2.sheet2 accordingly
I use two input box for file1 and file2 and got below details using field info :-
File1_Sheet_Name File1_Full_Path File2_Sheet_Name File2_Full_Path
Sheet1 C:\Users\File1.xlsx|||Sheet1 Sheet1 C:\Users\File2.xlsx|||Sheet1
Sheet2 C:\Users\File1.xlsx|||Sheet2 Sheet2 C:\Users\File2.xlsx|||Sheet2
Sheet3 C:\Users\File1.xlsx|||Sheet3 Sheet3 C:\Users\File2.xlsx|||Sheet3
Now I want to open both the files for sheet1 and save the different entries in output file.
So above table there are 3 entries will execute one by on and save the output for each sheet.
Please help me for further logic.
Appreciate your help.
Thank you.
Solved! Go to Solution.
Hello @alt_tush,
Does every sheet have the same column structure? I.e. file1 sheet1 has columns A, B, and C and so does file2 sheet1 and so does file1 sheet2... etc.
Sam :)
Yes structure is same.
Just I want to find the different data from both the files at sheet level
If sheet1 has col1 col2 then sheet2 have col1 col2 too. So just want to find out mismatch row from both the files. same for sheet2 and sheet3
Thanks for your reply :)
Ok, have a look at the attached.
I created 2 files with 3 sheets each. The first part of the workflow loads the filenames with a directory tool, then loads the list of sheet names for each and then uses a simple batch macro to load all the sheets from both files.
The second macro then compares sheet by sheet and writes the differences to a new file called differences.
You'll probably have to modify the unique tool and join tool in the find differences macro to work with the column names in your files. I didn't look into making this dynamic. Perhaps replacing these 2 tools with the "Only Unique" Crew Macro will make it more robust.
Thank you So Much David :)
It works. :)