Keep merged data from two data tables in same columns

Help
,
1

Hi,

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?

Thanks,

2

Are the datatables with equal columns?

3

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

4

So you better off just adding rows inside loops…

5

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

6

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

7

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

Thanks @bcorrea

1 Like
8

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