Details on Replace Data – Match Columns


This dialog is displayed when data have been replaced in your current document, but all columns used in the document could not be replaced automatically by columns in the new data table. It allows you to match columns from the current data table with columns from the new data table.

replacedata_match_columns_d.png

Option

Description

From current data

Lists the columns in the current data table that could not be replaced automatically. Click here to select the column you wish to match with a column from the new data, then click Match Selected.

From new data

Lists the columns in the new data table that has not been matched to columns from the current data table. Click here to select the column you wish to match with a column from the current data, then click Match Selected.

Match Selected

Matches the selected columns from the current data table and the new data table.

Matched columns

Lists all column pairs that have been selected for matching.

Unmatch All

Unmatches all the matched columns, including the automatically matched columns.

Unmatch Selected

Unmatches selected columns from the Matched columns list.

Cancel

Cancels the replace data table operation.

See also:

Replacing Data