Identifying differences between two table

Help Activities
, ,
1

Hi UiPath Community,

I have a problem I am facing right now.

I do have 2 data tables and I need to check for differences.

I performed the for loop however due to large numbers of loop being run, I am getting an error system.outofmemory

Is there a better way to identify differences in 2 data table?

for example please the image below for the scenario:

image
image761×473 6.62 KB

2

@aapostol

Try below expression.

         drNotMatchingRows = inputDT1.AsEnumerable.Except(inputDT2.AsEnumerable, DataRowComparer.Default).ToList

Where drNotMatchingRows is of type Array of Data Rows.

3

Hi @lakshman

How can I declared drNotmatchingRows as Array of Data Rows?

4

@aapostol

Select Array of [T]->Browse for Types ->System.Data.DataRow