Number of input and output field

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

The SplitToListThenJoin function reads the input as a single-line string and splits it into multiple lists.
Elements from these lists are then joined with elements at the same index positions across all lists, producing a single combined list.

Parameters of the SplitToListThenJoin Function

1. Lists separator :
   Specifies the delimiter used to separate individual lists.
2. List's values separator :
   Specifies the delimiter used to separate elements within each list.
3. Join Separator :
   Specifies the delimiter used to join corresponding elements from different lists.

Example :
Input text:

   1a|1b|1c;2a|2b|2c;3a|3b|3c|3d

Parameter values:

• Lists separator : ;
• List's values separator : |
• Join Separator : ,
  

Result :

   1a,2a,3a|1b,2b,3b|1c,2c,3c| , ,3d

Explanation:

• Each list is split using the list separator (;).
• Elements within each list are split using the values separator (|).
• Elements at the same index from all lists are joined using the join separator (,).
• If a list does not contain a value at a specific index, an empty value is inserted.