Power Query
published
Search
⌃K

List.Union

List.Union

Returns the union of the list values found in the input.
function (lists as list, optional equationCriteria as nullable any) as list

Description

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.

Category

List.Set operations

Examples

Create a union of the list {1..5}, {2..6}, {3..7}.
List.Union({ {1..5}, {2..6}, {3..7} })
{1, 2, 3, 4, 5, 6, 7}