Power Query
Search…
published
Powered By GitBook
Table.HasColumns

Table.HasColumns

indicates whether the table contains the specified column(s).
function (table as table, optional columns as nullable any) as logical

Description

indicates whether the table contains the specified column(s), columns. Returns true if the table contains the column(s), false otherwise.

Category

Table.Column operations

Examples

Determine if the table has the column [Name].
1
Table.HasColumns(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")
Copied!
true
Find if the table has the column [Name] and [PhoneNumber].
1
Table.HasColumns(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", "PhoneNumber"})
Copied!
false
Last modified 3yr ago