Keep merged data from two data tables in same columns


I need to merge five data tables into a sixth. I’m using the Merge Data Table activity.

When I merge them though, the data for each data table is taking up its own columns. How can I keep the data in the first set of columns?


Are the datatables with equal columns?

Yes. They’re being compiled from Excel spreadsheets with the same amount of data columns.

So you better off just adding rows inside loops…

I tried swapping the activity with a For each and add data row but that had no effect.

Please take a look at this example: Main.xaml (11.8 KB)

That did it - I was using the DataRow input property rather than ArrayRow.

Thanks @bcorrea

1 Like

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