Table of contents
TOC
Collapse the table of content
Expand the table of content

Table.DuplicateColumn

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

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 1

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
© 2018 Microsoft