Forum Discussion

rsantos1's avatar
rsantos1
New Member
7 years ago

Power query extract value of a json record

Hi,

 

Hi have a nested json file imported to excel, power query, they successfully tranforme to a table the values, but in the third column for example, there is a [Record] value, I want to write in each row the content of the json instead of the [Record], I don't want to transforme again in tables, I want the value of the record. Anyone can help to accomplish that?

 

Column1.name                   Column2.typebody          Column2.registo

 

Testeteste2[Record]
signalGET[Record]

 

Thank you

Show and Tell

8 Replies

    • rsantos1's avatar
      rsantos1
      New Member
      7 years ago

      I don't want to expand the json value in collumns, I want the raw json value like {"option", ...} and insert in each row, that's the clhallenge..

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        rsantos1,

        I am not very clear about your requirment. Could you please share sample data and expected result here?

        Regards,
        Lydia