Mapping the preparation and destination columns
The mapping step allows you to map columns before writing to a defined destination.
Relationships are represented by lines between the selected preparation and destination columns.
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.