Table.DuplicateColumn

Table.DuplicateColumn
Duplicates a column with the specified name. Values and type are copied from the source column.
function (table as table, columnName as text, newColumnName as text, optional columnType as nullable any) as table
Description
Duplicate the column named columnName to the table table. The values and type for the column newColumnName are copied from coulmn columnName.
Category
Table.Column operations
Examples
Duplicate the column "a" to a column named "copied column" in the table ({[a = 1, b = 2], [a = 3, b = 4]}).
Table.DuplicateColumn(Table.FromRecords({[a = 1, b = 2], [a = 3, b = 4]}), "a", "copied column")
Table.FromRecords({ [ a = 1, b = 2,
    #"copied column" = 1
], [
    a = 3,
    b = 4,
    #"copied column" = 3
]
}, { "a", "b", "copied column" })

Table.Distinct

Table.ExpandListColumn

Last modified 4yr ago