Find the difference in two excel files

[Ryan_Lee]

comparison - Copy.zip (177.0 KB)

i have successfully compared 2 files. i want you guys to help me find the differences of the 2 data of each person between annual and quarterly file to see if their row of data under each column in the same but using the NRIC as a primary key and place it in a new variable in a new excel sheet in any one of the two files.

if possible, come out with an solution for me and send me the file so i can refer to it. Much appreciated

[furkan.cosan]

solution.zip (246.9 KB)
Hi @Ryan_Lee,

I’ve created a solution for your request and attached the necessary files here. You can review the Solution.xaml file to see how the process works. This workflow compares two Excel files (Annual and Quarterly) by using the NRIC column as the primary key. It then identifies rows where all values in the other columns are identical and writes them into a new Excel file called Compared.xlsx.

Solution Summary:

• The NRIC column is used as the primary key for comparison.
• All other column values are checked row by row.
• Rows that are completely identical are written to a new Excel file (Compared.xlsx).

What you need to do:

1. Open the Solution.xaml file to review the workflow.
2. Check the output in the Compared.xlsx file.

If you encounter any issues or need to make changes to the workflow, feel free to reach out. I hope this helps!

Best regards!

[Ryan_Lee]

thanks bro that was great

[furkan.cosan]

You are welcome bro

[Ryan_Lee]

hi bro, i got a question. instead of bringing the putting data that are identical to a new excel file is it possible to put the data that are different to the new excel file. if yes, how do you do it? so instead of looking for the same rows look for the different rows

and make the nric and month the primary key when comparing and finding the differences. i forgot to tell you the month is the primary key also

also put the differences into a new excel sheet only the cell thats is wrong