Forum Discussion

lorish's avatar
lorish
Regular Visitor
2 years ago
Solved

Query successfully expands the "Record" values into columns and then collapses them again

Hello everyone 🙂 Thank you for your help. I really do appreciate it!   There is a problem with my power query M. It's a large JSON, which i do fold up into seperate columns with that query. It lo...
Need Help
  • collinsg's avatar
    collinsg
    2 years ago

    Good day lorish,

    The steps from #"Expanded issues.fields.issuetype" to #"Expanded issues.fields.status" each are of the form 

    Table.ExpandRecordColumn with the first parameter being the table they expand. In each case the table they expand is the table created by the step #"Expanded issues.fields". Therefore each step is taking that table and expanding part of it afresh each time. Instead each step should expand the table from the previous step. For example change
    #"Expanded issues.fields.fixVersions" = Table.ExpandRecordColumn(#"Expanded issues.fields ...etc
    to
    #"Expanded issues.fields.fixVersions" = Table.ExpandRecordColumn(#"Expanded issues.fields.issuetype ...etc

    Hope this helps

collinsg's avatar
collinsg
Icon for Solution Sage rankSolution Sage
2 years ago

Good day lorish,

The steps from #"Expanded issues.fields.issuetype" to #"Expanded issues.fields.status" each are of the form 

Table.ExpandRecordColumn with the first parameter being the table they expand. In each case the table they expand is the table created by the step #"Expanded issues.fields". Therefore each step is taking that table and expanding part of it afresh each time. Instead each step should expand the table from the previous step. For example change
#"Expanded issues.fields.fixVersions" = Table.ExpandRecordColumn(#"Expanded issues.fields ...etc
to
#"Expanded issues.fields.fixVersions" = Table.ExpandRecordColumn(#"Expanded issues.fields.issuetype ...etc

Hope this helps