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

Table.AddKey

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

About

Add a key to table.

Table.AddKey(table as table,  columns as list,  isPrimary as logical) as table  

Arguments

ArgumentDescription
tableThe Table to modify.
columnsThe subset of column names that defines the key.
isPrimarySpecifies whether the key is primary.

Example

let  
  
        table = 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"]  
  
    }  
  
),  
  
        resultTable = Table.AddKey(table, {"CustomerID"}, true)  
  
in  
  
        resultTable  
CustomerIDNamePhone
1Bob123-4567
2Jim987-6543
3Paul543-7890
4Ringo232-1550
© 2018 Microsoft