Need to merge two excel sheet and values

Hi All,

Here I attached 3 image
1st image contain database value
2nd image contain input value ( processing value)
3rd image I need this output for your reference.

Actually database contains all the values

Input sheet contain today processed value

I need to merge today data’s into database,

I mean if the values of equipment code is already present in database means need to update values which in input data.

So at last database value + input value (updated after process data) need to merge

Please give me solution for this which activity is better or if you have LINQ query means awesome to me

Thanks
Vicky



HI @Vicky_K

I guess you need the new rows between DataBase and Input DataTable, And want the Details of new records only which you can append in the output Excel File

You can use the following Expression:

inputDT.AsEnumerable().Except(DatabaseDT.AsEnumerable(), DataRowComparer.Default).CopyToDataTable

Here’s a sample Workflow
DataTableOps.xaml (11.8 KB)

InputDT:
image
DataBaseDT:
image
NewRecords:


Result: newRecords
image