Hello - Does anyone know how to join to data tables together even if it is of different structure and different column names?
Basically I am trying to join the two data tables while merging one column and adding the other columns as new columns. Would anyone know how I go about this?
Did you try to use the ‘Merge Data Table’ Activity?
You can join both datatable using Join Datatable activity
Please go through this
If you wanted to append rows to datatable , It can be done by append range activity .
Hope this helps you .
Thanks for your suggestions. I have attached the workflow to this. As you can see I am trying to join to DT together and merge two columns while adding the other columns as new columns.
Does this look right?Example.zip (13.7 KB)