0 ×

JSON Row Combiner

JSON related functionality for KNIME version 4.1.0.v201911110939 by KNIME AG, Zurich, Switzerland

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.

Options

JSON column
The JSON column providing the values for the array.
New column name
Name of the new (single, JSON) column in the output table.
Omit root
When selected, only the object or the array is returned (custom key/value pairs are not applicable).
Add root object with key
Key to the JSON values object or array in the root object.
Custom key/value pairs
Additional key/value pairs to the root object.
Collect into array
The rows are collected to a JSON array.
Collect into object with key
The rows become an object within another object with the keys specified by the selected column's values (will fail if there are duplicates).

Input Ports

Table with a JSON column

Output Ports

A single JSON value

Best Friends (Incoming)

Best Friends (Outgoing)

Workflows

Installation

To use this node in KNIME, install KNIME JSON-Processing from the following update site:

KNIME 4.1
Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform.

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.