Table.DuplicateColumn

Syntax

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

About

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

Example

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

a  |b  |copied column  
---------|---------|---------
1     |   2      |  1       
3     |   4      |   3