You can completely replace the columns in your dataset by selecting source columns, functions computed from the source, and constant values.
NOTE: This transformation completely replaces the existing table, which could have significant effects on any downstream recipes or reference datasets that already exist.
In the recipe, locate the step where you wish to insert the transformation to create your new table.
NOTE: If your Create Table transformation renames or omits columns, references to them later in your recipe or in other downstream objects may be broken.
Select. Choose the transformation.
A function. Example:
NOTE: When creating a table, aggregate and window functions are not supported. After you have created your table, you can apply these functions are normal.
A constant value. Example:
In the lower field, you enter a name for the column in the new table.
The new table replaces your previous set of columns.
Tip: After you have created your new table, you can disable or delete the step to revert to the previous state.
This transformation is added to your recipe when you perform column matching between your source dataset and a target schema. The results of your column matching work are rendered as a single Create Table transformation in your recipe.
Tip: If you have a target schema to which you can assign to your recipe, you may find it easier to create your new table using RapidTarget, which provides a visual interface for performing these remappings.
NOTE: RapidTarget does not support inserting columns containing constants or generated by functions. You can insert those column as a later step.
For more information, see Overview of RapidTarget.