Compare two excel tables- reconciliation

[Ashish_Mehra]

Hi All,

I am trying to compare two data tables with one common column and 15 different value columns with same headers in both tables. I am looking to reconcile both tables and output any row where any one of the 15 values are different. I want the recon report to output only that value for each unique ID where the value is different. Is there any easy way to achieve this ?

Any help is apprecaited

[Palaniyappan (Palaniyappan P)]

Did we try wit JOIN DATATABLE ACTIVITY where we can mention the primary column for joining, with appropriate join method

Cheers @Ashish_Mehra

[Ashish_Mehra]

@Palaniyappan I did join both the tables, but now I want to compare all the column values for each employee ID (Primary column) to all column values in the second report. The ouput required is a recon report with employee ID’s and values which are different in both reports. A full join would just join all data rows but I need specifically where the values are different or missing

[Palaniyappan (Palaniyappan P)]

Fine
did this thread met your requirement
kindly try once with this pls

Compare Datatables one specific column with other specific Column and Get Matched and Not Matched Records`

Hello Community Use Below Code to Compare 2 Datatable Column and Get Matched and Not Matched Records Note- Based on your datatable column datatype update datatype here with column field. To Get Matched Records Datatable Out_Matched_Data = In_DataTable1.AsEnumerable().Where(function(row) In_DataTable2.AsEnumerable().Select(function(r) r.Field(Of Int32)(In_DT2_ColName_To_Match.ToString)).Any(function(x) x = row.Field(Of Int32)(In_DT1_ColName_To_Match.ToString))).CopyToDataTable() To Get Not…

Cheers @Ashish_Mehra

[san.nagane]

Hi @Ashish_Mehra,

Please refer below thread.

Compare Datatables one specific column with other specific Column and Get Matched and Not Matched Records`

Hello Community Use Below Code to Compare 2 Datatable Column and Get Matched and Not Matched Records Note- Based on your datatable column datatype update datatype here with column field. To Get Matched Records Datatable Out_Matched_Data = In_DataTable1.AsEnumerable().Where(function(row) In_DataTable2.AsEnumerable().Select(function(r) r.Field(Of Int32)(In_DT2_ColName_To_Match.ToString)).Any(function(x) x = row.Field(Of Int32)(In_DT1_ColName_To_Match.ToString))).CopyToDataTable() To Get Not…

[Ashish_Mehra]

@Palaniyappan @san.nagane how can I use the above code to compare multiple columns, each excel sheet has 20 columns with unique employee ID , I am trying to compare values within all 20 for each employee. thank you!