JOIN_OF_ANY

Description

JOIN_OF_ANY is the flexible counterpart of JOIN. It puts together the known elements in a list and ignores them if they are not known / provided yet.

Examples

p is Person
JOIN_OF_ANY(
    [
        p.title,
        p.first_name, 
        p.middle_name, 
        p.last_name
    ], 
    ' '
)

This expression extracts the name components of a person, including title. If the case is about President (p.title) John (p.first_name) Fitzgerald (p.middle_name) Kennedy (p.last_name), this expression has as output:

'President John Fitzgerald Kennedy'

If only a first and last name have been filled out in the case, the return of this JOIN_OF_ANY expression is:

'John Kennedy'

Had the expression used the JOIN operator instead, and only ‘John’ and ‘Kennedy’ are known values, the system would have asked users to provide the missing values ‘title’ and ‘middle_name’, before giving you a result.