Matching row data between 2 large excel files (using DTs)

[jarrettd88 (Jarrett Disbennett)]

Hello, I have looked on the forum but cannot solve this problem. I have two very large data sets I need to compare in an efficient way. My plan is to create two data tables DT1 (original data ) and DT2 (results data ). These will be formatted the same way and basically I want to log the entire row if one of the cells does not match (create DT 3).

I have seen a few solutions that match based on a cell value but I need to match the entire rows (they will have the data in the same places and should match ). I will upload an example excel shortly. The reason I mentioned filtering by the entire row is because there are 26k rows and over 50 columns with unique data.

I know how to get the DTs up and just need help with the filtering portion.

[Jyotika_Halai]

Hi @jarrettd88,

Kindly check the below links:

Compare two datatable

Hi All, How to compare two dt. Ex dt1 contain 10 column Dt2 contain 11 column . If matching item in dt1 is present in dt2 then ,insert “match” in column 11.if not match then unmatch should be entered. All 10 column name are same.

Comparing two data tables

Hi Gaurav, I have attached the comparison logic workflow. Kindly let me know if you got struck somewhere. Thanks and regards, Ananthu Comparison logic.xaml (22.3 KB)