← Back to Table functions

Table.ColumnsOfType

This function will generate a list of column names from the given table that meet the criteria specified in the list of types.

Syntax

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

About

This function will generate a list of column names from the given table that meet the criteria specified in the list of types.

Explanation

Retrieve the column names that are of Number.Type from the Usage Power Query MTable. The function MTable.ColumnsOfType is used to carry out this task. The function is applied to a table created from records, with one record having the values of {[a = 1, b = "hello"]}. The columns of the table are set to have types a as Number.Type and b as Text.Type. In the end, the output will only show the column name "a" as it matches the Number.Type criteria.