Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
suvbin
Creator III
Creator III

Json data extraction

Hi , 

 

Is there any way to extract json column information and load into different columns in target table

Example input : '{"name":"John", "age":30, "car":null}'

output: 3 columns in table 

Name: John

Age: 30 

Car: Null

Labels (3)
2 Replies
sureshkumar
Support
Support

Hello @suvbin 

Please refer below white paper documentation for the json data extract

 

Regards,

Suresh

 

mufas12
Contributor
Contributor

There is JSON data in there from what I see, but you won't see it in your network activity. This is because this JSON data is embedded inside the HTML itself. Specifically, the JSON data is stored in the "q-data" attribute of the element with id="vue-match-centre". I'm not sure which scraping framework you use, but you will have to get the value of the "q-data".