Table.SelectColumns
TOC
Collapse the table of content
Expand the table of content

Table.SelectColumns

 

This topic applies to the Power Query Formula Language (informally known as "M") which can be used with Power Query and Power BI Desktop to build queries that mashup data. See the list of function categories.

Returns a table that contains only specific columns.

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

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.
  • Table.SelectColumns is similar to Record.SelectFields applied to every row in a table.
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
Show:
© 2016 Microsoft