Forum Discussion

data4thewin's avatar
data4thewin
Frequent Visitor
9 years ago
Solved

Extracting Data from a JSON Blob Column

I have a table that contains a JSON Blob in one of it's columns.  Can I extract the data into a tabular format?   {"$version":1,"observations":{"pests":{"41":{"count":{"unit":{"id":3,"name":"per t...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi data4thewin,

     

    Perhaps you can refer to below sample file.

    BTW, if you want format multiple records, I'd like recommend you use the records which has similar structure.

     

    Regards,

    XIaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi data4thewin,

 

Perhaps you can refer to below sample file.

BTW, if you want format multiple records, I'd like recommend you use the records which has similar structure.

 

Regards,

XIaoxin Sheng

data4thewin's avatar
data4thewin
Frequent Visitor
9 years ago

Thank you!!