Number of input and output field

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

This transformation function is used to duplicate a column value and transpose it into multiple rows.

Parameters

• Number of Duplication
  Specifies how many times the value should be duplicated.
• Counter Included
  Indicates whether a counter number should be included.
  When selected, each duplicated row will start with a counter followed by a tab and the original field value.

Example
Input:

Hot air balloon crashes near Denver

Function Parameter:

• Number of Duplication: 5

Output:

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

Function Parameter:

• Number of Duplication: 5
• Counter Included: Yes

Output:

| result                                    |
| ---------------------------------------   |
| 1 \t  Hot air balloon crashes near Denver |
| 2 \t  Hot air balloon crashes near Denver |
| 3 \t  Hot air balloon crashes near Denver |
| 4 \t  Hot air balloon crashes near Denver |
| 5 \t  Hot air balloon crashes near Denver |