How to Compare two data tables with specific Column data

[adarsh_kotagiri]

Hi Team,

Here i have two data tables DT_1 and DT_2,

DT_1:

DT_2:

for each row in DT_2 “Phone Number” if this Phone Number is not present in DT_1 “phone” then i need to pick that data row from DT_2 and update in another excel which is DT_Final(Output). as shown below

DT_Final:

Please suggest any solution through LINQ

Thanks and regards,
Sai Adarsh.

[Gokul001 (Gokul Balaji)]

Hi @adarsh_kotagiri

Can you share the sample excel file

Regards
Gokul

[Gokul001 (Gokul Balaji)]

Hi @adarsh_kotagiri

Check out this video link

UiPath- How to Compare two Data Tables| Output the similar and dissimilar rows |Faster method

Regards
Gokul

[adarsh_kotagiri]

Hi @Gokul001, Please find the below attachemnt

Data.xlsx (10.7 KB)

[Yoichi]

Hi,

Can you try the following sample?

DT_Final = DT_2.AsEnumerable.Where(Function(r) not DT_1.AsEnumerable.Any(Function(r2) r2("Phone").ToString=r("Phone Number").ToString)).CopyToDataTable.DefaultView.ToTable(False,{"Date","Phone Number","Currency"})

Sample20221123-2aL.zip (10.6 KB)

Regards,

[pranay.nandalaskar]

Hi @adarsh_kotagiri

PFBL for compare two datatable using LINQ.

Linq to compare two datatables using two keys

Hi @supermanPunch, thank you for your response. I need to use two columns, the “Amt” and “PAN” from each table to determine the duplicates.

[adarsh_kotagiri]

Thank you so much @Yoichi , now i cleared the concept