Power Query
published
Search
K

Table.ColumnsOfType

Table.ColumnsOfType

Returns a list with the names of the columns that match the specified types.
function (table as table, listOfTypes as list) as list

Description

Returns a list with the names of the columns from table table that match the types specified in listOfTypes.

Category

Table.Column operations

Examples

Return the names of columns of type Number.Type from the table.
Table.ColumnsOfType(Table.FromRecords({[a=1,b="hello"]}, type table[a=Number.Type, b=Text.Type]), {type number})
{"a"}