You are viewing the documentation for Blueriq 15. 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.


AttributeBasetypeValue
Person.namestring"John"
Person.date_of_birthdate01-01-1995
Person.family_namestring
ExpressionResultType
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



Back to Top