Actually a valid JSON object would be more:
If you cells were formatted as a JSON object you would then be able to use in a "Prepare recipe" the "Unnest object" step that would provide the expected output:
So the simplest options I see would be to:
- transform your data to have directly a JSON object that can be unnested
- you could perform that transformation in a "Prepare recipe" using for example a "Formula" step
- use a "Python function" step in "row" mode where you would for each row extract the new columns and corresponding values. More info on this step can be found in the documentation: Python function
I hope this helps.
Mickaël | R&D at Dataiku