Split Column
This transformation will split a single column into two on an identified separator. The settings are:
Which column to split: Type the name of the column here. Case sensitive.
Separator: What character will identify the split. Common ones are ‘-‘, ‘,’ or ‘.’.
First target column: Name the first of the new columns
Second target column: Name of the second of the new columns