Header Definition

Use this transformation to select the columns you want to keep in your dataset. If a column name is not mentioned here, they will be deleted and not loaded in. If a column is named that doesn’t exist in the original data set you’re loading in, it will be created with null values.

You can also use this to rearrange your data set. The order column names are mentioned will be the order of the data set coming out of the transformation.

The settings are:

Columns of new table: Enter the names of the column headers you want to keep. Separate names by comma (,). List names in the order you want the output data set in.