json to table

Hi team,

I have already few solution which are available in the forum’s. however i am not getting the output as expected.
[ {
“relation” : “Self”,
“range” : “18-35”
}, {
“relation” : “spouse”,
“range” : “18-35”
}, {
“relation” : “child”
}, {
“relation” : “child”
} ]

output expected:

|relation|range|
|self|18-35|
|spouse|18-35|
|child|null|
|child|null|

i have tried the using json path also.

.

Note: it’s woking when i am parsing all the column together but i need 2-3 column to be parse.

Is there any other option please let me know.

tried links.

1-2 more.

Hi @Hammy

You can use a JSON Path and Ungroup node to achieve this.

Use the queries $[*]['relation'] and $[*]['range'] in the Path node and ensure that you have the List checkbox enabled.

Then include both outputs in the ungroup node.

Hope this helps!

4 Likes

thank you, ArjenEX its working fine.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.