JSON tree to table

[JarkkoP]

HI Community,

I have an JSON data column, that has a JSON tree structured data in it (screenshot of data below and dataset attached) . I'm struggling to convert this to a table into the following format: 

Parent 1	Parent 2	Parent 3	Parent 4	Value
123	324	234		124,3
121	232			165,5
165	434	254	124	432,4

Is this possible to do with Alreryx and if it is, how ? :=)

Thanks!

[PhilipMannering · Accepted solution]

Looks like all your child objects are empty so the JSON Parse Tool isn't working.

Maybe this gets you started (see attached),

[PhilipMannering]

* edit: I think I mean to say JSON_Values are empty, not child objects.

[JarkkoP]

Thanks Philip! This will definitely help me forward :=) Have a great day! 

[JarkkoP]

Yes, they are still missing. Bad description from me. This is exactly what I wanted, thanks again :=)

[PhilipMannering]

Good stuff. Happy to help @JarkkoP