Hi, can anyone pls tell how to do the match/unmatch values in Uipath datatable comparing only one column and ignoring other columns for comparision?

[Pratheep]

Someone pls tell how to do match/unmatch across two datatable comparing only one column and ignoring other columns for comparision?

[arjunshenoy]

Hi @Pratheep, welcome to the Community.

Please checkout the following resource:

Comparing two data tables

Hi friends, Need a quick help! I want to compare two data tables. I need to compare each and every cell of first data table with those of the second data table (I. E., I need to find a row based on s.no. If that matches then each and every cell of that row has to be compared. ) and add those cells that aren’t same into a separate data table. Can anyone help me with this? Thanks in advance. Regards, Ananthu

Hope this helps,
Best Regards.

[rlgandu]

@Pratheep

Read Range (Excel Application Scope) → Output: dt1
Read Range (Excel Application Scope) → Output: dt2

For Each Row (ForEachRow1) → DataTable: dt1
For Each Row (ForEachRow2) → DataTable: dt2
If row1(“ID”).ToString = row2(“ID”).ToString // Compare based on the “ID” column
Then
// Handle matched rows
Else
// Handle unmatched rows
End If
End ForEachRow2
End ForEachRow1