Mapping the preparation and destination columns
The mapping step allows you to map columns before writing to a defined destination.
To start mapping, you can either:
- Drag and drop a preparation column on a destination column.
- Select a preparation column directly from the selection drop-down list or type the column name in the selection area.
The following rules apply when mapping columns together:
- (Beta) Automapping occurs when starting the second step of the run configuration.
- Unmapped preparation columns are ignored and will not appear in the destination
columns.
Example: Your preparation dataset contains these columns: first_name, last_name, email and phone and your destination dataset contains these columns: firstname, lastname, address and phone.
If you map first_name with firstname, last_name with lastname and phone with phone, your destination dataset will contain these columns: firstname, lastname, address and phone. The unmapped email column will be ignored. The address destination column will be empty.
- A mandatory destination column which is not mapped will most likely result in an error. It is still possible to run the preparation, but you may experience data loss or more errors, it is recommended to correct the mapping beforehand.
- If the destination dataset is a JDBC dataset: the values of the mapped
preparation columns will be added to their corresponding destination columns
according to the operation set for your database (insert, update, upsert,
delete) during the first step of the run configuration.
Example: If you selected the Insert action and your preparation column firstname contains the values Alice and John, and is mapped with the destination column first_name that contains the values Will and Alima, the preparation column will contain all these values after the mapping: Alice, John, Will and Alima, which corresponds to an insert.
- There is no schema modification when mapping columns, which means the name of
the mapped destination column will be kept over the name of the preparation
column when a preparation column is mapped with it.
Example: If you map the preparation column firstname with the destination column first_name, the mapped destination column will be named first_name.