Table.ColumnsOfType

About

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

Syntax

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

Arguments

Argument Description
Table The input table.
listOfTypes The 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"}