Number of input and output field
| Number of input field |
: |
Two or more |
| Number of output field |
: |
One |
The ListJoin function reads the input as a multi-line string, where each line is treated as a separate list.
Elements from each list are joined together based on their index positions, producing a single joined list.
Parameters of the ListJoin Function
- List's value separator
Specifies the delimiter used to separate elements within each list.
- Join Separator
Specifies the delimiter used to join elements from different lists that share the same index.
Example
Input (multiple lines):
1-a|1-b|1-c
2-a|2-b|2-c
3-a|3-b|3-c|3-d
Parameters :
List's value separator : |
Join Separator : ,
Result :
1-a,2-a,3-a|1-b,2-b,3-b|1-c,2-c,3-c|,,3-d
Explanation:
- Elements at the same index from each line are joined using the join separator.
- If a list does not contain an element at a particular index, an empty value is used in its place.