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

Settings

New column name

Name of the new JSON column

Omit root key

The array of JSON values selected (Selected JSON columns) will be returned without any other tags.

Custom key

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

Data bound key

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.

Remove source columns

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

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
• Excel to JSON Multilayer nested arrays objectsKNIME Forum
• JKISeason3-21_tarkKNIME Hub
• JSON combine columnsKNIME Hub
• JSON Path extract same attributes for different objects v2KNIME Forum
• knime_forum_jsonKNIME Forum

Links

• No links available

Developers