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

Table.SelectColumns

Owen Duncan|Last Updated: 4/19/2018

About

Returns a table that contains only specific columns.

Table.SelectColumns(table as table, columns as any, optional missingField as any) as table  

Arguments

ArgumentDescription
tableThe Table to modify.
columnsThe list of columns to copy.
optional missingFieldThe default value of missingField is MissingField.Error. For more information, see Parameter Values.

Remarks

  • Table.SelectColumns is similar to Record.SelectFields applied to every row in a table.

Examples

Table.SelectColumns(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"]  

}  

), "Name")  
Name
Bob
Jim
Paul
Ringo
Table.SelectColumns(Table.FromRecords({  

    [CustomerID=1, Name="Bob", Phone = "123-4567"]}), {"CustomerID", "Name"})  
CustomerIDName
1Bob
Table.SelectColumns(Table.FromRecords({  

    [CustomerID=1, Name = "Bob", Phone = "123-4567" ]}), {"CustomerID", "NewColumn"}, MissingField.UseNull)  
CustomerIDNewColumn
1null
© 2018 Microsoft