Compare SKU in 2 excels and Show only the Matched Skus in a new Excel

Help
1

I am trying to Compare SKU in 2 excels and Show only the Matched Skus (rows) in the 3rd excel.

Somehow it is just comparing only the first Row, not all rows. Also, the 3rd file is not getting written to disc… Here is my attached excels and the XAML as well.

Main.xaml (15.2 KB)
ExcelSheet1.xlsx (11.3 KB)
ExcelSheet2.xlsx (9.1 KB)

2

Hi @1easy,

I think the easier way is to use Join Data Tables activity, use inner join type and compare the column you want.

Cheers,
Q

3

Perfecto, works great :slight_smile:

4

Great! Happy Automating! :grinning:

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.