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

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