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 the column value based on a specified separator and string frame.
The separator may consist of a single character or multiple characters.

Parameters

• Splitter String
  Specifies the string or regular expression used to split the input value.
• Open String Frame
  Specifies the opening string frame.
• Close String Frame
  Specifies the closing string frame.
• 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
• Open String Frame: (
• Close String Frame: )

Output:

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

Function Parameters:

• Splitter String: \s
• Open String Frame: (
• Close String Frame: )
• Counter Included: Yes
• Delimiter between Counter & Content: |

Output:

| result              |
| --------------------|
| 1|Hot               |
| 2|air               |
| 3|(balloon crashes) |
| 4|near              |
| 4|Denver            |