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, 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" })
Last modified 4yr ago