Append two data tables

[Bob2 (Bob)]

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?

[lucas.stern]

Did you try to use the ‘Merge Data Table’ Activity?

[AshwinS2 (Ashwin S)]

Hi @Bob2

Check this

Merge Data Table different Column Names

Hello I have 2 data Tables as below: Data Table 1 : [image] Data Table 2 : [image] Output: [image] in the both the data table few columns are same but in the one column name is different characters so in that cell constant word is Name i need to merge that column into where column name contains Name in that location any one can help Thanks in advance Regards Shriharsha

Thanks
Ashwin S

[karthick]

Hi,

You can join both datatable using Join Datatable activity

Please go through this

Join Data Tables

If you wanted to append rows to datatable , It can be done by append range activity .

Hope this helps you .

[Bob2 (Bob)]

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)