JSON Processing to a new table

Five Stars

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

Nine Stars

Re: JSON Processing to a new table

Hi,

 

are you looking for following output?

jsonLoop.PNG

 

Regards,

Veeru Boppudi
Five Stars

Re: JSON Processing to a new table

can you please explain the each components working