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.

Root configuration

Configure how to handle the root object.

• Omit root: When selected, only the object or the array is returned (custom key/value pairs are not applicable).
• Add root object with key: When selected, the object or the array is added to a root object with the specified key. Custom key/value pairs can also be added to the root object.

Root 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.

• Key: The key name.
• Value: The key value.

Collection type

Configure how to collect the JSON values.

• 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).

Object key column

The column providing the keys for the object when collecting into object. The rows become an object within another object with the keys specified by the selected column's values (will fail if there are duplicates). Select "RowID" to use the Row IDs as object keys.

Views

This node has no views

Workflows

• 01_D3_JS-ExampleKNIME Hub
• 01_Guided_Analytics_for_ML_AutomationKNIME Hub
• 01_Guided_Analytics_for_ML_AutomationKNIME Hub
• 01_Guided_Analytics_for_ML_AutomationKNIME Hub
• 01_Guided_Analytics_for_ML_AutomationKNIME Hub
• Show all 124 workflows

Links

• No links available

Developers