Hi, I’m hoping you can help me! I’m new to JSON and I’m new to Knime. I’m working with a JSON file structured like this: [image] I want to be able to write to a table where the “ @k ” values are column headers and the “@v” values are populated under the appropriate column heading. Looking at the image above, I want “addr:city” to be a heading and “Derby” to be a value underneath that heading. I’ve created a JSON Path that gets me: [image] . After Ungrouping and using JSON to Table, I get the following, which still isn’t right. [image] Does anyone have any advice that can get me back on course? Thanks in advance. Cheers - John.

Hello @Unlockedata , I see. Take a look at this workflow: 2021_01_14_JSON_Manipulation_Mod.knwf (57.5 KB) Probably this can be done somehow without using loop but might be an overkill. Br, Ivan

Creating columns from JSON

KNIME Analytics Platform

ipazin January 15, 2021, 10:18am 9

Hi @Daniel_Weikert,

I see now you meant on post about sharing data. Well there is this topic I try to point users to:

Probably it’s worth writing it down somehow somewhere but not sure main forum page is the right place.

Br,
Ivan

1 Like