Combines JSON values to a single JSON value (an array optionally wrapped in an object) for each row. Example configuration:
Input table:

S	R	V
2	[1]	"S"
3	{"a":2}	{"T": null}

Selected JSON columns: R and V
Data bound key: S (String)
Results:

{"2": [[1], "S"]}

{"3": [{"a": 2}, {"T": null}]}

Options

New column name

Name of the new JSON column

Remove source columns

When checked, the included columns and the data bound key/value columns will be removed from the resulting table

Root key type

How to create the root of the JSON value: Unnamed root elements generate JSON without a wrapping key, Custom key uses a constant key for all rows, Data bound key uses a column value from each row as the key

• Unamed root elements: Generate JSON without a wrapping key.
• Custom key: Use a constant key for all rows.
• Data bound key: Use a column value from each row as the key.

Custom key name

The constant key for the array of JSON values selected (Selected JSON columns)

Data bound key column

The column name, whose values become the key for the array of JSON values selected (Selected JSON columns)

Selected JSON columns

The included columns will be combined to a new JSON value for each row

Views

This node has no views

Workflows

• 09_Schedule_Jobs_via_WebPortal_on_KNIME_ServerKNIME Hub
• 09_Schedule_Jobs_via_WebPortal_on_KNIME_ServerKNIME Hub
• ADVNVAi_label_GVisionKNIME Hub
• Bundle Items (REST)KNIME Hub
• Excel to JSON Multilayer nested arrays objectsKNIME Forum
• Show all 12 workflows

Links

• No links available

Developers