DataTable result compare

[372402124]

I used Table extraction get two datatable, may I know if we need to save datatable to excel to compare or any activity able to compare directly?

[aanandsanraj (Anandraj Rajendran)]

@372402124

You can compare two datatable using below code

dtOutput = dt1.AsEnumerable().Except(dt2.AsEnumerable(), DataRowComparer.Default);

In dtOutput if found any count then there is difference

dtOutput.Count

[Rahul_Unnikrishnan]

Hello @372402124

You can directly compare the 2 datatables and get the similar and dissimilar rows.

UiPath- How to Compare two Data Tables| Output the similar and dissimilar rows |Faster method

Thanks

[372402124]

i try with this way and got error message

is it because data not from row2? this is a report which had a 2 rows title here

[Rahul_Unnikrishnan]

This is happening as the columns are having the same names. Datatable should not have the same named columns.

Thanks

[372402124]

i went through the columns name for the report, looks like no two columns had totally same name, how to identify where it throw error?

[372402124]

This working well to get total different number

[Rahul_Unnikrishnan]

can you search with 2442 and see whether that value is there in the excel?

Thanks

[372402124]

Yes, Rahu, i search 2442 and there are 3 cell had this value, but that is data only, not column name

[Rahul_Unnikrishnan]

Can you please share the screenshot of Read range activity which you are using? Also, have you enabled the Is Header option?

Thanks

[372402124]

Yes, Rahul, i enabled Is_header option,pls refer to my read range activity and excel format

[Rahul_Unnikrishnan]

can you provide the range as well. In your excel first cell is blank and the range should start from A2.

Else first remove the first row in the sheet, then use read range activity.

Thanks

[372402124]

try with start A2, got read range output datatable as this