JSON to table help

[Green_Man]

Hello,
I am using trying to read from JSON to a table in knime, but some of the data is in the format
{
“Title” : [
{
“@Section1” : “true” ,
“@Section2” : “true” ,
“text” : “DisplayedText”
},
{
“@Section1” : “true” ,
“@Section2” : “true” ,
“text” : “DisplayedText”
}
]
}
I want to be able to read this as a table looking something like this:
@Section 1 | @Section2 | text
true |true |DisplayedText
true |true |DisplayedText
But i am having issues displaying the data in this way, although I can write it all as one long row.

Does anybody know of a solution or would be able to point me in the right direction?

Thank you.

[mlauber71]

You could try this Workflow

Json to Table

I just stumbled across this entry and maybe I can help since I had a similar problem recently. The point is that in order to import a JSON file you have to Import it with the JSON reader define a JSON path to the variables ungroup the variables Then you have a normal table with columns. json.knar

[Green_Man]

This works beautifully, thank you very much!