Join the array of items into a string with a separator.
Note that array functions can only be used when the values are first aggregated by a rollup field or when the input field is a lookup.
Removes empty strings and null values from the array. Keeps "false" and strings that contain one or more blank characters.
Note that array functions can only be used when the values are first aggregated by a rollup field or when the input field is a lookup.
Flattens the array by removing any array nesting. All items become elements of a single array.
Note that array functions can only be used when the values are first aggregated by a rollup field or when the input field is a lookup.
Returns only unique items in the array.
Note that array functions can only be used when the values are first aggregated by a rollup field or when the input field is a lookup.