The Union() function produces a concept set with all the concepts from a collection of concept sets and concepts (needs the List() function to combine literal sets and concepts).

Combining concepts and concept sets into a new concept set can also be achieved using addition (+).

Read general information about Concepts and Ontology

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a new concept set with all concepts provided in the parameter list. This collection can contain concepts from different parents.

Returns Unknown if one of the parameter values is unknown.


Union( List(concepts | concept_sets) )

Union( List('Colors'.'Orange', 'Colors'.'Red', 'Colors'.'Blue') ) =>Result: { orange, red, blue } as a new concept set

Union( [Products.Markets] of [Products] ) =>Result: a combination of only the Markets that are stored in multi-select field in Products, for example { 'APAC', 'EMEA', 'CIS', 'LATAM', 'NA' }. Using the [multi-select-field] of [list] results in a list of concept-sets, so the List() function is not necessary in this case.

Union( List(GetChildren('Color'), [AllDevices], 'Status'.'Assigned') ) =>Result: a combination of all color-children concepts, all Devices from conceptset and the Assigned status concept.

Similar results can be achieved with addition:

'Colors'.'Orange' + 'Colors'.'Red' + 'Colors'.'Blue'

List(GetChildren('Color') + [AllDevices] + 'Status'.'Assigned'



List(concepts | concept_sets)

A list of concepts and/or concept-sets

a list of separate concepts or concept-sets

Last updated