Comparison of two Datatables using two keys

Help Studio
, , , ,
10

Hi @riyatona18

Please check this implementation. Not so optimized but will work.

  1. Read the excel files to respective data table variables (DT1, DT2)
  2. Create column name array and get the names of columns
  3. Create the output data table template (Clone method)
  4. Iterate through the rows and column and compare each item of both the tables.
  5. Add the row to the output table
  6. Write the output to excel file

DT_ComparisonTwoDataTables.zip (17.0 KB)