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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

JSON Processing to a new table


i have a table structure like

id    name    age        place        details

1    max    26        florida        [{ "height":"175","weight":65","status":"single"}]    

2    vikki    32        miami        [{ "colour":"black","height":"165","status":"single"}]    

3    john    25        texas        [{ "street":"yald","car":"yes","status":"single","height":"165"}]



we have to process the json column and expected out to a new table and its structure should be like:
note:"In details column the key and values are different"


id    attributename    attributevalue.

1    height        175

1    weight        65

1    status          single

2    colour            black

2    status          single

2    street        yald

3    car        yes

3    status          single

3     height        165

Labels (3)
2 Replies
vboppudi
Partner - Creator III
Partner - Creator III

Hi,

 

are you looking for following output?

0683p000009LwqP.png

 

Regards,

Anonymous
Not applicable
Author

can you please explain the each components working