I am trying to merge 2 data tables side by side so that they appear horizontally. However when I use the merge data tables activity the tables appear underneath one another. Please let me know how I can fix this. I will include the output of the merge tables function. The tables have nothing in common.
@scott.luntz Are the Number of rows in each Datatable the same ?
The merge datatables activity only works if you have a key on which to merge the data. It looks like what you’re trying to do is drop the datatables into the workbook as-is without the need of a key. If this is the case, you can follow these steps:
1.) Read your data into your separate datatables.
2.) Write each table individually into separate columns of the workbook. The first datatable will be written to A1, the next into B1, etc.
No they are not
What activity should I use to write the tables into separate columns?
You can use Write Range, and you’ll need to write each table to the column which follows each table. So if you know that table 1 has 5 rows, the next would be written to F1.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.