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

Table.ColumnsOfType

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

About

Returns a list with the names of the columns that match the specified types.

Table.ColumnsOfType(table as table, listOfTypes as list) as list  

Arguments

ArgumentDescription
TableThe input table.
listOfTypesThe types to match columns types on.

Example

let  
  
  tableValue = Table.FromRecords({[a=1, b="hello"]}, type table[a=Number.Type, b=Text.Type])  
  
in  
  
  Table.ColumnsOfType(tableValue, {type number})  
  
equals {"a"}  
© 2018 Microsoft