Number of input and output field

Number of input field	:	One
Number of output field	:	One

This transformation function transposes a column into multiple rows by splitting its value.

Parameters

• Splitter String
  Specifies the string or regular expression used to split the input value.
• Counter Included
  Indicates whether a counter should be included in the output.
• Delimiter between Counter & Content
  Specifies the separator between the counter and the content.
  Default value: tab (\t).

When the counter is included, the output format is:
counter + separator + content

Example
Input:

Hot air balloon crashes near Denver

Function Parameters:

• Splitter String: \s

Output:

| result  |
| ------- |
| Hot     |
| air     |
| balloon |
| crashes |
| near    |
| Denver  |

Function Parameters:

• Splitter String: \s
• Counter Included: Yes
• Delimiter between Counter & Content: |

Output:

| result    |
| --------- |
| 1|Hot     |
| 2|air     |
| 3|balloon |
| 5|crashes |
| 6|near    |
| 7|Denver  |