How to compares two different data tables and get unmatched values?

[makboga]

Hi,
I have two different data tables OrderDT

and SAPDT

I need to compare these two data table and get the unmatched values.

I want to compare “ORDER” column in OrderDT and “Doc No” in SAPDT.

For example, the values 54321 and 78654 are not in the table SAPDT I want to get these values.

Thanks.

[michael.zura (GuardiansFan)]

@makboga

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

How to compare 2 datatable values

Hi - I have 2 datatable with only 1 col and I need to find if Data table 2 has all the values in Data table 1.[Uipath] Finding how values in List2 matches from List1. Thanks

Regards

[ppr (Peter Preuss)]

one of many approaches

Assign Activity:
arrOrders | String Array
dtOrder.AsEnumerable.Select(Function (x) x(“ORDER”).toString.Trim).Distinct().ToArray()

Assign Activity:
arrDocNos | String Array
dtSAP.AsEnumerable.Select(Function (x) x(“Doc No”).toString.Trim).Distinct().ToArray()

Assign Activity
arrMissing | String Array
arrOrders.Except(arrDocNos).toArray