Linq query compare datatable

I need to compare the two DT(input1.xlsx and input2.xlsx) and get the result as output1.xlsx using linq query. Currently am using lookup data table activity and this is taking more time to complete the task.

I do have 1 lakh records to perfrom.

Input1.xlsx (8.5 KB)
Input2.xlsx (8.6 KB)
Output.xlsx (8.6 KB)

Hey @Manikandasamy

Could you please explain here what to compare with snaps ?


To compare : (Common column name)
input 1 → Name
input 2 → Name

Output :

input 1 file should take age from input 2 file and it has to print in status(Age) column, and based on the age value it has to update the remarks as well.


Can you share the excel.

@Vaibhav_Rajpoot_17 The excel is attached in the first tag.

Hi @Manikandasamy ,

Could you Check the Workflow Below : (16.4 KB)

The Workflow uses Join Datatable Activity to join the Datatables based on the Name column.
We then add the new Columns Required.

Next, Loop through the rows of the Datatable using a For Each Row Activity and update the Remarks Column.

We also define the Output Column Names required to be preserved in the Output Datatable in an array.

For Converting the Number to Words assuming that is what was required for Remarks Column we use the Below Package :

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.