Insert json multiple field in one column

[Informatique1]

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]

Hi

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]

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