Identifying differences between two table

aapostol · September 29, 2021, 5:03am

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:

lakshman · September 29, 2021, 5:09am

Try below expression.

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

Where drNotMatchingRows is of type Array of Data Rows.

aapostol · September 29, 2021, 5:18am

How can I declared drNotmatchingRows as Array of Data Rows?

lakshman · September 29, 2021, 7:15am

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