topic Insert json multiple field in one column in Talend Studio

Insert json multiple field in one column

Informatique1 — Fri, 15 Nov 2024 22:56:53 GMT

Hello,

I have this data in a row with some IDs, and another row which is a Json like that:

ID | json

111| {"1": "AAA"},{ "2": "BBB"},{ "3": "CCC"}

222| {"1": "AAA"}

333| {"1": "AAA"},{ "2": "BBB"}

What I would like is to insert in one table of 2 columns like that:

ID | choice

111 | AAA

111 | BBB

111 | CCC

222 | AAA

333 | AAA

333 | BBB

Any suggestions?

Thanks a lot

Anonymous — Tue, 10 May 2022 07:36:44 GMT

Using a tNormalize component to split the json column to multiple rows, and then extract the value from json string using tExtractJsonField.

Please try and let me know if you have any issues/questions.

Regards

Shong

Informatique1 — Fri, 13 May 2022 07:51:55 GMT

Hello,

Thanks a lot for your answer.

Well I did not have the opportunity to test it because the specs of the project change... and I don't need this anymore 😕

Regards