Details on Insert Rows – Match Columns

Option

Description

From current data

Lists all columns in the current data. Click here to select the column you wish to match against a column from the new data, then click Match Selected.

From new data

Lists all columns in the new data. Click here to select the column you wish to match against a column from the current data, then click Match Selected.

Match Selected

Sends the selected column pair (From current data and From new data) to the Matched columns list.

Match All Possible

Sends all column pairs that have the same external ID or, of subordinate importance, columns with the same name to the Matched columns list.

Matched columns

Lists all column pairs that have been selected for matching.

Unmatch Selected

Removes the selected column pair from the Matched columns list.

Unmatch All

Removes all column pairs from the Matched columns list.

Next >

Continues to the next step of the wizard where it is possible to determine if additional columns should be included and whether or not to use a column to identify the origin of new rows.

Finish

Adds all available new rows and includes data from any new columns that were not used in the matching.