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:


merge with


to form


Hi @Zac_Soh

use merge datatable activity and check it

Ashwin S

Merging with MissingSchemaAction “ignore” gave me only


other options threw me error " Datatype property mismatch"

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

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?

1 Like

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