Split Column values

The Split Column values transformer allows you to split column values.

Split Column values Transform dialog is shown as below:

1. Enter Title like most of the other transforms. Ensure that the Title is uniquely identifying the step
2. Enter Description to provide further information for this particular step. This is helpful in ensuring the transform step is readable in a complex workflow, ensuring readability. This step however, is Optional.
3. Split On : This field will allow you to choose between the available options.
4. Pattern/value : This field allows the user to enter the delimiter or the value or the regex pattern based on the split on method.
5. Output Column Prefix should be given for the new column name .
6. Click Create to add the step to the recipe.

Supported options under Split on are :

1. Delimiter
2. Exactly Matches
3. Regex Pattern