Union

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.

Syntax

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'

Parameters

Name
Type
Required
Description

List(concepts | concept_sets)

A list of concepts and/or concept-sets

☑️

a list of separate concepts or concept-sets

Last updated

Was this helpful?