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
Popular Predecessors
- Columns to JSON8 %
- Table to JSON5 %
- String Manipulation5 %
- Row Sampling4 %
- String to JSON4 %
- Column Filter3 %
- JSON to Table3 %
Joiner3 %Column Appender3 %- Loop End3 %
- Cross Joiner3 %
- Concatenate2 %
Row Filter (deprecated)2 %Row Splitter (deprecated)2 %- Column Aggregator2 %
Recursive Loop End1 %- Column Expressions1 %
- Table Creator1 %
- JSON Path1 %
- Constant Value Column1 %
- XML to JSON1 %
- Rule-based Row Filter1 %
- Java Snippet1 %
Concatenate (Optional in)1 %Column Rename1 %- Column Splitter1 %
- JSON Row Combiner1 %
- Excel Reader1 %
- JSON Reader1 %
- List Files/Folders1 %
- Chunk Loop Start< 1 %
- GroupBy< 1 %
- RowID< 1 %
- Table Transposer< 1 %
- Ungroup< 1 %
- JSON Column Combiner< 1 %
- JSON Transformer< 1 %
JSON Reader< 1 %- GET Request< 1 %
- Group Loop Start< 1 %
- Column Combiner< 1 %
- Column Appender< 1 %
- Joiner< 1 %
- MongoDB Reader< 1 %
- CSV Reader< 1 %
- Partitioning< 1 %
- Container Input (JSON)< 1 %
- Column to XML< 1 %
Table Column to Variable< 1 %- JSON Path (Dictionary)< 1 %
MongoDB Reader< 1 %Regex Extractor< 1 %Variable to Table Row< 1 %Cell Splitter< 1 %- Column Resorter< 1 %
- JSON Schema Validator< 1 %
- Unpivot< 1 %
- JSON to XML< 1 %
- XML Column Combiner< 1 %
Loop End< 1 %- Missing Value< 1 %
- XML Row Combiner< 1 %
CSV Reader< 1 %File Reader< 1 %Table Reader< 1 %- Sorter< 1 %
- Java IF (Table)< 1 %
- POST Request< 1 %
- String Manipulation (Multi Column)< 1 %
- Path to URI< 1 %
Loop End (2 ports)< 1 %- Column Merger< 1 %
- Rule-based Row Splitter< 1 %
XLS Writer< 1 %Excel Reader (XLS)< 1 %Table Column to Variable< 1 %Table Row to Variable< 1 %Line Reader< 1 %- Column List Loop Start< 1 %
- Create Byte Vector< 1 %
- Expand Byte Vector< 1 %
- Number to String< 1 %
- Column Rename (Regex)< 1 %
- Reference Row Splitter< 1 %
- String Manipulation (Variable)< 1 %
- String Replacer< 1 %
- Math Formula< 1 %
- String Configuration< 1 %
- Python Source (legacy)< 1 %
- HTTP Retriever< 1 %
- Line Reader< 1 %
- Variable Condition Loop End< 1 %
- Table Row to Variable Loop Start< 1 %
- Duplicate Row Filter< 1 %
- Nominal Value Row Splitter< 1 %
- Normalizer (PMML)< 1 %
- Rule Engine< 1 %
- DB Writer< 1 %
- Association Rule Learner (Borgelt)< 1 %
- Column Selection Configuration< 1 %
- JSON Writer< 1 %
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 67 workflows
Links
- No links available
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.