Category: Text function
This function returns a deduplicated list with all values from list1 and list2.
| Argument | Type | Description |
|---|---|---|
| list1 | List (Text) | A delimited set of string values. |
| list2 | List (Text) | A delimited set of string values. |
| separator | Text | The delimiter to use in the concatenation of the output string. If not defined, the default is comma. |
Return value type: Set (Text)
All leading and trailing spaces are removed from around the list values.
setunion("A, B", "B,C") //returns "A,B,C"
setunion("A;B", "C ;D", ";") //returns "A;B;C;D"