How to compare the values of 2datatables

i have one datatable dt1 it contains column customer number
and dt2 it also contains column customer number
i have to compare the values of datatables dt1 and dt2 client customer number values how do i do that .

Hi @Gayathri_Mk

Use the LinQ expression below!

From d1 In dtData1.AsEnumerable
Join d2 In dtData2.AsEnumerable
On d1(YourColumnNameOrIndex).ToString() Equals d2(“YourColumnNameOrIndex”).ToString()
Select d1).CopyToDataTable



You can use join datatable activity in Uipath. and use this column from both the tables for comparing.

Sruthi YNM

Before selecting the implementation approach just cross check the requirement and e.g. what type of joining you do need. Have a look here: