Table.HasColumns
Table.HasColumns(table as table, columns as any) as logical
Geeft aan of de table
de opgegeven kolom(en), columns
bevat. Retourneert true
als de tabel de kolommen bevat, false
anders.
Bepalen of de tabel de kolom [Naam] bevat.
Gebruik
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"
)
uitvoer
true
Zoeken of de tabel de kolom [Naam] en [PhoneNumber] bevat.
Gebruik
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"}
)
uitvoer
false