Forum Discussion

AshleyWells's avatar
AshleyWells
Regular Visitor
3 years ago
Solved

JSON data stored in 2 lists. 1 columns header, 1 data. Need to make into a table

Hi all,   I was wondering if anyone has any experience in converting multiple rows of JSON data that is stored as 2 lists, 1 as column headers and the other as the data and transforming them into 1...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi AshleyWells 

     

    Please add a custom column with this. Notice that there is a pair of {} around [ColumnData]. 

    = Table.AddColumn(PreviousStep, "Custom", each #table([ColumnNames],{[ColumnData]}))

    Then expand the custom table column. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi AshleyWells 

 

Please add a custom column with this. Notice that there is a pair of {} around [ColumnData]. 

= Table.AddColumn(PreviousStep, "Custom", each #table([ColumnNames],{[ColumnData]}))

Then expand the custom table column. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

AshleyWells's avatar
AshleyWells
Regular Visitor
3 years ago

v-jingzhang that works perfectly, thanks so much!