How to convert a nested JSON into a table

Hi community,

I’m struggling with converting a nested JSON to a table for hours now. I have already looked at many forum entries about it, but have not found the solution anywhere or it does not work for me.

Check the JSON and desired output below.

I tried it as I found in response of ArjenEX (JSON parse) with two JSON Path Nodes in a row and afterwards with an Ungroup Node:

First JSON Path:

Second JSON Path:

But I didn’t get the desired result:

This is the JSON input:

sample.json

This is the desired output:

I hope, somebody can help me with my issue.

Thomas

I’m working with KNIME 5.2.5 Build June 04, 2024