List.Union
Returns the union of the list values found in the input.
Syntax
List.Union(
lists as list,
optional equationCriteria as any
) as list
Remarks
Takes a list of lists lists
, unions the items in the individual lists and returns them in the output list. As a result, the returned list contains all items in any input lists. This operation maintains traditional bag semantics, so duplicate values are matched as part of the Union. An optional equation criteria value, equationCriteria
, can be specified to control equality testing.
Examples
Example #1
Create a union of the list {1..5}, {2..6}, {3..7}.
List.Union({{1..5}, {2..6}, {3..7}})
Result:
{1, 2, 3, 4, 5, 6, 7}
Category
List.Set operations