Table.DuplicateColumn

 

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

Duplicate the column named columnName to the table table. The values and type for the column newColumnName are copied from column columnName.

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")

abcopied column
121
343
Show: