Table of contents
TOC
Collapse the table of content
Expand the table of content

Table.Distinct

Owen Duncan|Last Updated: 4/19/2018

About

Removes duplicate rows from a table, ensuring that all remaining rows are distinct.

Table.Distinct(table as table, optional equationCriteria as any) as table  

Arguments

ArgumentDescription
tableThe Table to modify.
optional equationCriteriaAn optional value that specifies how to control comparison between the rows of the table

Examples

Table.Distinct(  

    Table.FromRecords(  

{  

    [OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100.0],  

    [OrderID = 2, CustomerID = 1, Item = "1 lb. worms", Price = 5.0],  

    [OrderID = 3, CustomerID = 2, Item = "Fishing net", Price = 25.0],  

    [OrderID = 4, CustomerID = 3, Item = "Fish tazer", Price = 200.0],  

    [OrderID = 5, CustomerID = 3, Item = "Bandaids", Price = 2.0],  

    [OrderID = 6, CustomerID = 1, Item = "Tackle box", Price = 20.0],  

    [OrderID = 7, CustomerID = 5, Item = "Bait", Price = 3.25],  

    [OrderID = 8, CustomerID = 5, Item = "Fishing Rod", Price = 100.0],  

    [OrderID = 9, CustomerID = 6, Item = "Bait", Price = 3.25]  

}  

), "CustomerID")  
OrderIDCustomerIDItemPrice
11Fishing rod100
32Fishing net25
43Fish tazer200
75Bait3.25
96Bait3.25
© 2018 Microsoft