Merge Data Table Activity

[Asiri (Asiri Gamage)]

Can anybody show me how to use the Merge Data Table activity?I tried to use it with 2 tables with common column as the key column.But still getting an error,

Message: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

I tried using T1,T2 as follows.
T1: ID,Name
T2: ID,Address

I also followed the following post.But also want to know how to use this particular activity to achieve merging.

Merge two datatables with common column

Hi i would like to use merge datatable activity but would like to ask what would happen if both datatables only have one common column, and i would like to merge all columns according to that common column. eg. Table 1 Name Age A 11 B 12 Table 2 Name Address A USA B UK to become Table 3 Name Age Address A 11 USA B 12 UK

[syedabidraza (syed)]

The error you got occur due to - duplicate rows being returned with the same primary key.
Try with the new values …

[Asiri (Asiri Gamage)]

Can you also explain the use of “AddWithKey” for Missing schema action?