Forum Discussion
Solved
How to expand record column dynamically with Power Query
I am expanding the specifications column. The available data is expanding successfully. But when the records are aaded in future in specification column it does not expand it all. What query will h...
= Table.ExpandRecordColumn(#"Reordered Columns", "specifications",Record.FieldNames(Record.Combine(product_data[specifications])))
= Table.ExpandRecordColumn(#"Reordered Columns", "specifications",Record.FieldNames(product_data[specifications]{0}))
As per your suggestion I Expanded the column with above code but it does not expanding all the records in specification column itself.
= Table.ExpandRecordColumn(#"Reordered Columns", "specifications",Record.FieldNames(Record.Combine(product_data[specifications])))
I try to tackle the same issue but keep getting the error that there is a loop. How can I make sure i indicate the right column?