All of the values in the selected JSON column are combined into a single JSON structure. Depending on the Place resulting JSON setting, the combined rows are either placed Under root key (as the value of that key) or At top level in the output. You can use Additional properties to add custom key/value pairs next to the combined JSON. The Combine rows as option controls whether the rows are collected into an Array or into an Object with key (using a key column to name each entry). For example, when combining rows as an array under a root key with additional properties, the output looks like this:

{
  "JSON key": [
    { "json": "from Row1" },
    { "json": "from Row2" }
  ],
  "custom key": "custom value"
}

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.

Combine rows as

Configure how to collect the JSON values.

• Array: The rows are collected into a JSON array.
• 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.

Place resulting JSON

How to structure the resulting JSON output.

• Under root key: Place the resulting JSON under a root key alongside optional additional properties.
• At top level: Generate resulting JSON as top level object.

Root object key

Key under which to place the resulting JSON.

Additional properties

Additional key/value pairs to add to the root object.

• Key: Additional property key.
• Value: Additional property value.

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