Compare two DTs and match each cell

[ronanpeter]

When you are joining two tables, they should have the same structure

How can I merge two data tables?

Hi @vivek_Chowdary I have a sample workflow on Merge data table. You can check it out. The main task of merge data table activity is to combine the data of two data tables into one single data table. So, for this to work, the structure of both datatables should be the same. So check out the workflows, and see how it can be done… mergeExcelDataTable.xaml (11.0 KB)

However, as you are reading data from SQL, you may want to get the data into excel first, then read it from there to be sure the table metadata is the same:

Datatable comparison: Error displayed as Data tables must have the same structure

Hi Ramesh, Try to save the SQL datatable to excel and read as datatable and compare with excel datatable and it should work.