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, optionalcolumnType
as nullable any) as table
Duplicate the column named columnName
to the table table
. The values and type for the column newColumnName
are copied from coulmn columnName
.
Table.Column operations
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" })