Read two ranges into one datatable?

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.

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.


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

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?

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.