Forum Discussion

Parth_1's avatar
Parth_1
Helper I
2 years ago
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...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    2 years ago

    = Table.ExpandRecordColumn(#"Reordered Columns", "specifications",Record.FieldNames(Record.Combine(product_data[specifications])))

AlienSx's avatar
AlienSx
Super User
2 years ago

Parth_1 if all records have the same set of fields then read field names into some variable using Record.FieldNames(your_table[specifications]{0}) and use it in expand step. 

  • Parth_1's avatar
    Parth_1
    Helper I
    2 years ago

    = 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.

    • wdx223_Daniel's avatar
      wdx223_Daniel
      Community Champion
      2 years ago

      = Table.ExpandRecordColumn(#"Reordered Columns", "specifications",Record.FieldNames(Record.Combine(product_data[specifications])))

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        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?

    • AlienSx's avatar
      AlienSx
      Super User
      2 years ago

      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's avatar
        Parth_1
        Helper I
        2 years ago

        Thank You for the solution and suggestion.