Mapping Columns

The Column Map screen is used to alter the mapping of source to destination columns for a table. It may also be used to bulk delete columns.

Access this screen by pressing the Map link in the table bar:

Ajilius will then display a list of all columns from the table, with a drop-down list for each column.

For Load tables, this list displays the options None and Delete. For all other tables, this list displays the options None, Delete, and a list of source table column names.

Choosing the None option for a column will cause that column to be NULL when processed.

Choosing the Delete option for a column will remove that column from the destination table.

Choosing another column name from the dropdown list will source the destination column from the newly selected source column.

Press the Save button to make the changes to your metadata, or press the Cancel button to exit from this screen without updating your metadata.