Array Formatting
1. :arrayJoin(separator, index, count)
Syntax Explanation
Joins an array of strings or numbers into a single string.
Parameters:
- separator: The delimiter (default is a comma
,). - index: Optional; the starting index from which to join.
- count: Optional; the number of items to join starting from
index(can be negative to count from the end).
Example
Result
The output is a string created by joining the array elements according to the specified parameters.
2. :arrayMap(objSeparator, attSeparator, attributes)
Syntax Explanation
Transforms an array of objects into a string. It does not process nested objects or arrays.
Parameters:
- objSeparator: The separator between objects (default is
,). - attSeparator: The separator between object attributes (default is
:). - attributes: Optional; a list of object attributes to output.
Example
Result
The output is a string generated by mapping and joining the array elements, ignoring nested object content.
3. :count(start)
Syntax Explanation
Counts the row number in an array and outputs the current row number.
For example:
Regardless of the value of id, it outputs the current row count.
Starting from v4.0.0, this formatter has been replaced internally by :cumCount.
Parameter:
- start: Optional; the starting value for the count.
Example and Result
In use, the output will display the row number according to the sequence of the array elements.