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 (+).
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.
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.
