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

Extension

This node is part of the extension

KNIME JSON-Processing

v4.0.0

Short Link

Drag node into KNIME Analytics Platform