Share via

Table.HasColumns

  • Article

Syntax

Table.HasColumns(table as table, columns as any) as logical

About

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

Example 1

Determine if the table has the column [Name].

Usage

TTable.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"
)

Output

true

Example 2

Find if the table has the column [Name] and [PhoneNumber].

Usage

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"}
)

Output

false