Comment on page
Table.IsDistinct
Indicates whether the table contains only distinct rows (no duplicates).
function (table
as table, optionalcomparisonCriteria
as nullable any) as logical
Indicates whether the
table
contains only distinct rows (no duplicates). Returns true
if the rows are distinct, false
otherwise. An optional parameter, comparisonCriteria
, specifies which columns of the table are tested for duplication. If comparisonCriteria
is not specified, all columns are tested.Table.Membership
Determine if the table is distinct.
Table.IsDistinct(Table.FromRecords({ [CustomerID = 1, Name = "Bob", Phone = "123-4567"], [CustomerID = 2, Name = "Jim", Phone = "987-6543"] , [CustomerID = 3, Name = "Paul", Phone = "543-7890"] , [CustomerID = 4, Name = "Ringo", Phone = "232-1550"]}))
true
Determine if the table is distinct in column.
Table.IsDistinct(Table.FromRecords({ [CustomerID = 1, Name = "Bob", Phone = "123-4567"], [CustomerID = 2, Name = "Jim", Phone = "987-6543"] , [CustomerID = 3, Name = "Paul", Phone = "543-7890"] , [CustomerID = 5, Name = "Bob", Phone = "232-1550"]}), "Name")
false
Last modified 5yr ago