Forum Discussion
Solved
ExpandRecordColumn versus ExpandListColumn
Problem: when expanding a JSON dataset, programmatically, you can expand a list of Tables using Table.ExpandListColumn, specifying only the column name to be expanded, which is fine. But if you want ...
Hi john_dawson,
you can use this function instead:
(Table as table, ColumnName as text) => Table.ExpandRecordColumn(Table, ColumnName, Record.FieldNames(Table.Column(Table, ColumnName){0}))It automatically expands all fields of the records that are found in the first rows record.
If the records are different and the names of all records within that column have to be taken into account, you can use this function instead:
= (Table as table, ColumnName as text) => Table.ExpandRecordColumn(Table, ColumnName, Record.FieldNames(Record.Combine(Table.Column(Table, ColumnName))))
might be a bit slower then
Hi john_dawson,
you can use this function instead:
(Table as table, ColumnName as text) =>
Table.ExpandRecordColumn(Table, ColumnName, Record.FieldNames(Table.Column(Table, ColumnName){0}))It automatically expands all fields of the records that are found in the first rows record.
If the records are different and the names of all records within that column have to be taken into account, you can use this function instead:
= (Table as table, ColumnName as text) => Table.ExpandRecordColumn(Table, ColumnName, Record.FieldNames(Record.Combine(Table.Column(Table, ColumnName))))
might be a bit slower then
Woo-hoo, thank you! The first function worked for me!