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
- Row Sampler5 %
Joiner4 %Column Appender4 %- Cross Joiner3 %
Row Splitter (deprecated)2 %- String Manipulation2 %
- Column Aggregator2 %
Recursive Loop End2 %- Column Expressions (legacy)2 %
- Table Creator2 %
- Table Transposer2 %
- String to JSON2 %
- JSON Path2 %
Constant Value Column2 %- XML to JSON2 %
- Java Snippet1 %
Concatenate (Optional in)1 %Column Rename1 %Column Splitter1 %- Table to JSON1 %
- Columns to JSON1 %
- JSON to Table1 %
- JSON Row Combiner1 %
- Excel Reader1 %
- JSON Reader1 %
- List Files/Folders1 %
- Chunk Loop Start1 %
- Concatenate1 %
- Column Filter1 %
Row Filter (deprecated)1 %- GroupBy1 %
- RowID1 %
- Ungroup1 %
- JSON Column Combiner1 %
- JSON Transformer1 %
JSON Reader1 %- GET Request1 %
- Group Loop Start1 %
- Column Combiner1 %
- Loop End1 %
- Column Appender1 %
- Joiner1 %
- Rule-based Row Filter1 %
- MongoDB Reader1 %
- CSV Reader1 %
- Table Manipulator1 %
- Table Partitioner< 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 Name Replacer< 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 123 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.