Table.DuplicateColumn

Syntaksi

Table.DuplicateColumn(table as table, columnName as text, newColumnName as text, optional columnType as nullable type) as table

Tietoja

Monista sarake columnName taulukkoon table. Sarakkeen newColumnName arvot ja tyyppi kopioidaan sarakkeesta columnName.

Esimerkki

Monista sarake "a" sarakkeeksi nimeltä "copied column" taulukossa ({[a = 1, b = 2], [a = 3, b = 4]}).

Käyttö

Table.DuplicateColumn(
    Table.FromRecords({
        [a = 1, b = 2],
        [a = 3, b = 4]
    }),
    "a",
    "copied column"
)

Tuloste

Table.FromRecords({
    [a = 1, b = 2, #"copied column" = 1],
    [a = 3, b = 4, #"copied column" = 3]
})