Table.AddColumn

Syntax

Table.AddColumn(
    table as table,
    newColumnName as text,
    columnGenerator as function,
    optional columnType as nullable type
) as table

About

Fügt der Tabelle newColumnNameeine Spalte mit dem Namen table hinzu. Die Werte für die Spalte werden mithilfe der angegebenen Auswahlfunktion columnGenerator berechnet, wobei jede Zeile als Eingabe verwendet wird.

Beispiel

Add a number column named "TotalPrice" to the table, with each value being the sum of the [Price] and [Shipping] columns.

Verwendung

Table.AddColumn(
    Table.FromRecords({
        [OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100.0, Shipping = 10.00],
        [OrderID = 2, CustomerID = 1, Item = "1 lb. worms", Price = 5.0, Shipping = 15.00],
        [OrderID = 3, CustomerID = 2, Item = "Fishing net", Price = 25.0, Shipping = 10.00]
    }),
    "TotalPrice",
    each [Price] + [Shipping],
    type number
)

Output

Table.FromRecords({
    [OrderID = 1, CustomerID = 1, Item = "Fishing rod", Price = 100, Shipping = 10, TotalPrice = 110],
    [OrderID = 2, CustomerID = 1, Item = "1 lb. worms", Price = 5, Shipping = 15, TotalPrice = 20],
    [OrderID = 3, CustomerID = 2, Item = "Fishing net", Price = 25, Shipping = 10, TotalPrice = 35]
})

Verwandte Inhalte

• Typen und Typkonvertierung