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

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.