Table.CombineColumnsToRecord
The process involves merging the designated columns from a table into a new column that contains records, named newColumnName. Each record includes field names and values that match the corresponding ...
Table.CombineColumnsToRecord(table as table, newColumnName as text, sourceColumns as list, optional options as nullable record) as tableThe process involves merging the designated columns from a table into a new column that contains records, named newColumnName. Each record includes field names and values that match the corresponding column names and values from the merged columns. If options are provided in the form of a record, the following options can be included:
- DisplayNameColumn: By specifying a text, the given column name will be used as the display name of the record. This column does not have to be included in the record itself.
- TypeName: By specifying a text, a logical type name is provided for the resulting record. This can be used during data loading to influence the behavior of the loading environment.