JSON Row Combiner

Manipulator

Combines JSON values in a column to a single JSON value (with an array for the JSON values from the column). The output looks like this:

{
  "JSON key": [
    {"json":"from Row1"},
    {"json":"from Row2"}
  ],
  "custom key":"custom value"
}
where the JSON key can be specified with the Add root object with key parameter, the "custom key":"custom value" is specified with the Custom key/value pairs and the Collect into array options.
All columns and rows will be removed or collapsed to a single cell.

Input Ports

  1. Type: Data Table with a JSON column

Output Ports

  1. Type: Data A single JSON value

Find here

Structured Data > JSON

Make sure to have this extension installed:

KNIME JSON-Processing

Update site for KNIME Analytics Platform 3.7:
KNIME Analytics Platform 3.7 Update Site

How to install extensions