Forum Discussion
Parth_1
2 years agoHelper I
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...
- 2 years ago
= Table.ExpandRecordColumn(#"Reordered Columns", "specifications",Record.FieldNames(Record.Combine(product_data[specifications])))
AlienSx
2 years agoSuper User
Parth_1 make sure that product_data has valid records in specifications column. Try solution provided by wdx223_Daniel but still pay attention to product_data table.
Parth_1
2 years agoHelper I
Thank You for the solution and suggestion.