Power Query
published
Search
⌃K

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