How can I merge two data tables?

I have 2 data tables in which I need to get values from column 1 of the 1st data table and merge it with a second data table. Can anyone please explain to me how to achieve this task.

Hello, this might help you more.

Please let us know if this helped you.
Kind Regards

1 Like

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)

hi @vivek_Chowdary

use merge datatable activity if the no cloumns is equals in both the datatables if not you need iterate through each in datatable and the assign the data to another datable or you can use vbscript to add the first column from one datatable to another datatable.

1 Like

Hi @vivek_Chowdary,

Please refer to this post.

Thank you

1 Like