Excel Automation

I want to compare two excel sheets and copy the non duplicate lines to new excel file. How can I achieve the same?

Hello @junaid98shaikhjsgma

You can use the two separate Microsoft Excel Input steps to read the two sheets and then use the Merge Join step to merge the data of the two sheets. And, then use the Formula step to check if the data from the two sheets matches or not.

I’ve attached a sample workflow for your reference.
DataCompareTwoSheets.xls (23 KB)
WF_CompareTwoSheets.psw (24.3 KB)

1 Like

Thank you @KalyaniW