Merging data

The Merge tool allows you to specify a from (source) table and identifier column and a to (target) table and identifier column.  This defines a merge path.

For a Merge path, you can define columns that will be inserted or updated from the source to the target column.  If the target is a link type of column, the link property will need to define what column to lookup in the link table using the source column's data as the key.

Once the Merge path is defined, click its Run button to perform the merge.

Pictures coming soon....