Bagikan melalui


Table.AddColumn

Sintaksis

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

Tentang

Menambahkan kolom bernama newColumnName ke tabel table. Nilai untuk kolom dihitung menggunakan fungsi pilihan yang ditentukan columnGenerator dengan setiap baris yang diambil sebagai input.

Contoh 1

Tambahkan kolom angka bernama "TotalPrice" ke tabel, dengan setiap nilai menjadi jumlah kolom [Harga] dan [Pengiriman].

Penggunaan

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