From table to nested JSON file

[havi1970]

Hello,

I am trying to create a nested JSON file from a database file. I’ve created this JSON file but two things are missing:

• Object is not showing, only the key;
• Datapoint key is not showing only the value “coord_lat”

Can somenone help me with this

[havi1970]

Can someone help me with this?

[ScottF]

Hi @havi1970 -

Would it be possible for you to post an example workflow? It would help to see the configuration options you’re using. Maybe then we can narrow down the problem.

[havi1970]

Hello Scott,
This is my latest attempt to create the nested JSON. What I want is:

object
datapoint
value
value
value
datapoint
value
object
etc.

InputJson.xlsx (5.8 KB)
JSON2(2).knwf (12.0 KB)

[marten_kose]

Hi @havi1970

you were almost there:

1. Instead of the Group Loop Start node you can directly start putting your values in JSON structure.
2. Group by ObjectID, ObjectConnector and DatapointID

The rest works fine. This way you’ll get a nicely nested JSON. For clarification I attached the modified workflow for you.

Cheers,
MartenJSON2(2).knwf (27.8 KB)

[havi1970]

Hi Marten,

Thanks, this is what i am looking for!

Cheers,
Peter