How to Compare two datatables and write only unique values in first datatable

Hello Everyone,

I need to Compare two excels excel1 and excel2 and write the unique values in excel1 to excel3.Please refer excels and how to achieve this excel3 excel1.xlsx (7.8 KB) excel2.xlsx (7.8 KB) excel3.xlsx (7.8 KB)

1 Like

Hey @raghuramk,

Here is a workaround for you.

Kindly check the excel 3 for output. Hope that is the one expected.

PFA - ExcelConsolidation.zip (19.3 KB)

Thanks :slight_smile:

Hi @raghuramk

Here is the solution for you !!! Check it out !!

uncommon.xaml (6.5 KB)
Just pass in your path in Variables of Excel 1, Excel 2, Excel 3

Happy Learning !!

1 Like

Hi,

See if the solution here helps, it worked for me

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