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

[raghuramk (raghuram)]

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)

[Nithinkrishna]

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

[Rakesh_Sampath]

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 !!

[LB34]

@raghuramk

I need to Compare two excels excel1 and excel2 and write the unique values in excel1 to excel3.Please r

Hi,

See if the solution here helps, it worked for me

How to remove duplicates in merge data table to get unique values?

Hi All, I am merging to data table, 1 data table is from early this morning with data in it, I have another newer data table I just scraped both have same column names There is a good chance they will have the same data plus more in the newer data table I can merge both tables, however I want to remove all duplicates, not just 1 set of duplicates All I want to be left with is rows that had no duplicates. Is there a way to do that? I tried 'remove duplicate rows, which it did, just not th…