Read two ranges into one datatable?

Help
, ,
1

hi i am trying to use read range twice into one datatable but the second read range is overwriting the data from the first read range.

I have built the table at the top of my workflow then using read range within the same one

any suggestions?

i need the data all in one table.

2

Hi @J_Swali,

Use the two different variables for the Output variable. If you want to merge those two tables, use Merge Data Table Activity.

3

@J_Swali,

Check this post, it has the solution which you are looking

4

whenever i use merged activity im getting over a 100 " , " in the log message when i try to output the merged table to see if the data im merging is correct?

5

If it’s the same column name then it will be attached to the same column, otherwise it will be created as new column. Try write the excel file and see the output.