json to table

[Hammy]

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.

Using JSON to table

Hi, I have a json table where I need to extract PO line items as separate rows. Each line needs to include the PO header details. I am using the JSON Path node and Ungroup node. But am unable to extract the data correctly. When there are multiple PO’s it repeats each POLineItem for every PO. So the example below if there was another PO with 3 lines. Instead of a total of 6 lines (3 for each PO) I am get 12 lines. [ { "PONumber" : "PO295", “date" : "2019-02-25", "Vendor" : "V9999", [ { "…

JSON to Table

Hi, which is the best/easiest way to extract relevant data from JSON to a table? JSON looks like: [image] This is what my table should look like: [image] Thomas

Json to Table

Thi issue makes the JSON to table node almost pointless. It's not a table if it has 1 row. I have tried so many settings in the node and couldnt get it to give me a table with a basic JSON input of 5 fields. it converts everything to columns instead. Here is an example of the data structure, I want this to yield 3 rows: [ { "date":1439006400, "amount":50 }, { "date":1439035200, "amount":51 }, { "date":1439049600, "amount":49 } ]  

1-2 more.

[ArjenEX]

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!

[Hammy]

thank you, ArjenEX its working fine.