Skip to content

Latest commit

 

History

History
18 lines (13 loc) · 1009 Bytes

table-combinecolumnstorecord.md

File metadata and controls

18 lines (13 loc) · 1009 Bytes
Raw
description title
Learn more about: Table.CombineColumnsToRecord
Table.CombineColumnsToRecord

Table.CombineColumnsToRecord

Syntax

Table.CombineColumnsToRecord(table as table, newColumnName as text, sourceColumns as list, optional options as nullable record) as table

About

Combines the specified columns of table into a new record-valued column named newColumnName where each record has field names and values corresponding to the column names and values of the columns that were combined. If a record is specified for options, the following options may be provided:

  • DisplayNameColumn: When specified as text, indicates that the given column name should be treated as the display name of the record. This need not be one of the columns in the record itself.
  • TypeName: When specified as text, supplies a logical type name for the resulting record which can be used during data load to drive behavior by the loading environment.