Columns to JSON

Manipulator

The columns values are transformed to JSON objects for each row. When there are conflicting keys, the result is undefined, might vary between different versions of KNIME.

An example transformation:
From table:

Main Num text
main1 2 Hello
main2 1 World

with custom key/values: const and val, Main as data bound key, Num with manual num key and text as automatic:

{"main1":{"text": "Hello", "num": 2, "const":"val"}}
{"main2":{"text": "World", "num": 1, "const":"val"}}

Input Ports

  1. Type: Data Table with values.

Output Ports

  1. Type: Data Table with the row-wise generated JSON column.

Find here

Structured Data > JSON

Make sure to have this extension installed: