JOIN Operation
How to use the JOIN operation for Computed Attributes
Definition
The JOIN operation lets you concatenate, or link, values with a delimiter.
Example
JOIN(["a", "b"], "-")
Result:
a-b
Syntax Guide
JOIN([values], delimiter)
values - The values to be appended using delimiter, confined by a set of brackets [ ]
delimiter - The character or string to place between each concatenated value
ℹ️ The delimiter may be specified as blank, e.g. JOIN(["1","2","3"],)
In this case the result would be: 1 2 3
Formula In Use
What's Next?
- Learn more about how to write formulas
- Learn how to create a computed attribute
- Check out the LEN operation
If you have any questions just click on the chat box in the bottom-right corner and we'll be happy to answer them...
and please let us know 👇