JOIN
Joins a series of values into one string, separated with a character of your choice.
Syntax
JOIN ( argument1 , argument2 , ... , separator ) |
Inputs
- argument1, argument2 - Attributes or expressions that contain the values that will be joint to a single string. JOIN works for all base types, even multivalued.
- separator - A string value that will be used as separator symbol.
Return type
- string
| an UNKNOWN value will be represented as an empty entry in the result string. |
The |
Examples
Suppose you have a model containing the following attributes.
| Attribute | Basetype | Value |
|---|---|---|
| Person.name | string | "John" |
| Person.date_of_birth | date | 01-01-1995 |
| Person.family_name | string |
| Expression | Result | Type |
|---|---|---|
| JOIN ( Person.name , Person.date_of_birth , ";" ) | "John;Sun Jan 01 00:00:00 CET 1995" | String |
| JOIN ( Person.name , Person.name , "@" ) | "John@John" | String |
| JOIN ( Person.name , Person.family_name , YEARS BETWEEN Person.date_of_birth AND DATE ( 2015 , 01 , 01 ) , ";" ) | "John;;20" | String |