Match DT data with other DT and get the email address

[Palaniyappan (Forum Leader)]

Hi

We can do this simply with a lookup datatable activity

Have a view on this doc for more detail

Activities - Lookup Data Table

Or if u would like to go expressions then this thread looks suitable for ur scenario

How to lookup two data tables?

Hi @aishwarya1 u can try this assume dt1 —> sheet1 dt2 -----> sheet2 dt3_uncommon= (From r1 in dt2.AsEnumerable Where dt1.AsEnumerable().Where(Function(row) row(“Organization Name”).ToString.Trim.Equals(r1(“Organization Name”).ToString)).Count=0 Select r1).CopyToDataTable Now use append range or merge datatable to merge the dt1 and dt3_uncommon to a excel sheet. Regards, Nived N

Cheers @Sathish_Kumar_S