Merge data table using ID

I have a data table with ID as first columns and some other data columns, and another data table that i built with ID as first columns as well as 6 others.
How can i merge using ID so that it is in this way:

ID|A|B|C

merge with

ID|1|2|3

to form

A|B|C|ID|1|2|3

Hi @Zac_Soh

use merge datatable activity and check it

Thanks
Ashwin S

@AshwinS2
Merging with MissingSchemaAction “ignore” gave me only

ID|1|2|3

other options threw me error " Datatype property mismatch"

can you send the workflow so we can try different options for you
thanks

thanks all, found a straightforward answer by moving the column to the back using set ordinal and then combine the rest of the columns

what does this mean?

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.