The Analyst tool can map source and target columns in a mapping specification based on column names and column positions. The Analyst tool can also map columns based on advanced criteria that you enter for column names and column positions. You can also select each source and target column to map the columns.
Use the
Advanced
mode in the
Automap
window to enter the column mapping criteria.
When you map by column name, the Analyst tool maps columns by name. For example, the Analyst tool maps ACCOUNTS to ACCOUNTS.
When you map by column position, the Analyst tool maps the first or last source column with the target column you select. For example, the Analyst tool maps the first source column ACCOUNTS_PAID to the target column ACCOUNTS.