You are viewing the documentation for Blueriq 14. Documentation for other versions is available in our documentation directory.
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 CONCAT function is identical to the JOIN function, except for handling of UNKNOWN.
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 |
Overview
Content Tools