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 1Parent 2Parent 3Parent 4Value123324234 124,3121232 165,5165434254124432,4 Is this possible to do with Alreryx and if it is, how ? :=) Thanks! Parse tree to table.yxmd

JSON tree to table

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!

Parse tree to table.yxmd

Best Practices

Accepted answers

philipmannering

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

Maybe this gets you started (see attached),

Parse tree to table.yxmd

All comments

philipmannering

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

Maybe this gets you started (see attached),

Parse tree to table.yxmd

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703