Table.HasColumns

  • Artículo

Sintaxis

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

Acerca de

Indica si table contiene las columnas especificadas, columns. Devuelve true si la tabla contiene las columnas, de lo contrario, devuelve false.

Ejemplo 1

Determinar si la tabla tiene la columna [Name].

Uso

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

Salida

true

Ejemplo 2

Buscar si la tabla tiene las columnas [Name] y [PhoneNumber].

Uso

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

Salida

false