Removes duplicate rows from the table.
function (
table
as table, optionalequationCriteria
as nullable any) as table
Removes duplicate rows from the table table
. An optional parameter, equationCriteria
, specifies which columns of the table are tested for duplication. If equationCriteria
is not specified, all columns are tested.
Table.Membership
Remove the duplicate rows from the table.
Table.Distinct(Table.FromRecords({[a = "A", b = "a"], [a = "B", b = "b"], [a = "A", b = "a"]}))
Table.FromRecords({[a = "A", b = "a"], [a = "B", b = "b"]}, { "a", "b" })
Remove the duplicate rows from column [b] in the table ({[a = "A", b = "a"], [a = "B", b = "a"], [a = "A", b = "b"]})
.
Table.Distinct(Table.FromRecords({[a = "A", b = "a"], [a = "B", b = "a"], [a = "A", b = "b"]}), "b")
Table.FromRecords({[a = "A", b = "a"], [a = "A", b = "b"]}, { "a", "b" })