JSON Processing to a new table

Anonymous — Wed, 18 Apr 2018 14:08:39 GMT

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

Re: JSON Processing to a new table

vboppudi — Wed, 18 Apr 2018 16:10:00 GMT

Hi,

are you looking for following output?

Regards,

Re: JSON Processing to a new table

Anonymous — Thu, 19 Apr 2018 05:58:59 GMT

can you please explain the each components working

topic Re: JSON Processing to a new table in Talend Studio

JSON Processing to a new table

Re: JSON Processing to a new table

Re: JSON Processing to a new table