How to compare the values of 2datatables

[Gayathri_Mk]

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 .

[pravin_calvin (pravin kumar)]

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

Regards

[ynm_Sruthi]

Hi,

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

Regards,
Sruthi YNM

[ppr (Peter Preuss)]

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

Story line of Join Data Table

Dear innovator’s, All we know that there is a Join Data table activity in UiPath.If we get any matching scenarios with unique value will approach join data table activity instead of filter/loop/array matching activity to find an exact match. Join Data Table: [image] Combines rows from two tables by using values common to each other, according to a Join rule, which is specified in the Join Type property. Sample Table: [image] INNER Join: The INNER JOIN keyword selects records that have m…