Contents of 2 excels into one based on column name

[Md_Saiful_Khaleque]

Dear experts,
pls see the attached pic. I want those 2 excel tables are concatenated in a new excel having the same headers. As you can see that the column header sequence differs between the 2 excels. Also to know that how to copy-paste from the end of entries of a certain column (these excels are dynamic in nature; every time the number of entries will vary).

[Rahul_Unnikrishnan]

Hello @Md_Saiful_Khaleque

Have you tried the Merge datatable activity?

UiPath Tutorial | Merge Data table & Join Data tables activity | Comparison and property explanation

Thanks

[Dawodm (Mahmoud Dawod)]

Hi @Md_Saiful_Khaleque

You can use the following LINQ query to do that:
Add an Assign activity and add your first table on the left side.
On the right side write the following query:

(
From row in YourSecondTable
Select YoutFirstTable.Rows.Add({row(“Name”),row(“MO Name”),row(“First Occurence”)})
).CopyToDataTable

Please make sure, you add the columns in the correct order.
It means, you should have the columns in your first table in this order:
Name - MO Name - First Occurence
If the order is not the same, you have to change the following line:
row(“Name”),row(“MO Name”),row(“First Occurence”)

[Md_Saiful_Khaleque]

Brother, would you please elaborate more or any other way…I am not comfortable with LINQ queries.