The columns values are transformed to JSON objects for each row. When there are conflicting keys, the result is undefined, might vary between different versions of KNIME.
An example transformation:
From table:
| Main | Num | text |
|---|---|---|
| main1 | 2 | Hello |
| main2 | 1 | World |
with custom key/values:
const
and
val,
Main
as data bound key,
Num
with manual
num
key and
text
as automatic:
| {"main1":{"text": "Hello", "num": 2, "const":"val"}} |
| {"main2":{"text": "World", "num": 1, "const":"val"}} |
Options
Popular Successors
- POST Request7 %
- JSON Row Combiner5 %
- JSON Writer5 %
- JSON to Table4 %
- JSON Path3 %
- Joiner3 %
CSV Writer3 %- Column Filter3 %
- GroupBy2 %
- String Manipulation2 %
- Table to JSON2 %
- JSON Transformer2 %
- JSON Column Combiner2 %
- Create Collection Column1 %
- Loop End1 %
Row Filter (deprecated)1 %- PUT Request1 %
- End IF1 %
- Column Expressions1 %
- Columns to JSON1 %
- Generic JavaScript View (JavaScript)1 %
- JSON to XML1 %
- GET Request1 %
- Constant Value Column< 1 %
- String to JSON< 1 %
- Container Output (JSON)< 1 %
MongoDB Save< 1 %- JSON Row Combiner and Writer< 1 %
- Container Input (Table)< 1 %
- Python Script (legacy)< 1 %
- PATCH Request< 1 %
- Table Row to Variable< 1 %
- Java Snippet< 1 %
- Chunk Loop Start< 1 %
- Column List Loop Start< 1 %
- Column Aggregator< 1 %
- Cross Joiner< 1 %
Row Splitter (deprecated)< 1 %- Reference Row Splitter< 1 %
Column Rename< 1 %- String Replacer< 1 %
- CASE Switch End< 1 %
- Call Workflow (Row Based)< 1 %
Table Row to Variable< 1 %- CSV Writer< 1 %
- Table Row to Variable Loop Start< 1 %
- Concatenate< 1 %
- Cell Splitter< 1 %
- Column Appender< 1 %
- Column Resorter< 1 %
- Table Validator< 1 %
- Table Manipulator< 1 %
- Partitioning< 1 %
- String Splitter (Regex)< 1 %
- RowID< 1 %
- String Manipulation (Variable)< 1 %
- Ungroup< 1 %
- DB Table Creator< 1 %
- Container Input (Row)< 1 %
- Container Output (Table)< 1 %
- JSON Path (Dictionary)< 1 %
- JSON Diff< 1 %
- JSON Schema Validator< 1 %
JSON Writer< 1 %- MongoDB Writer< 1 %
- Group Loop Start< 1 %
Cell Replacer< 1 %Joiner< 1 %- XML to JSON< 1 %
- Variable to Table Column< 1 %
- Loop End (Column Append)< 1 %
Concatenate (Optional in)< 1 %- Column Renamer (Dictionary)< 1 %
Excel Writer (XLS)< 1 %MongoDB Writer< 1 %- Date&Time to String< 1 %
- XML Row Combiner< 1 %
- XPath< 1 %
- Split Collection Column< 1 %
- Try (Data Ports)< 1 %
Table Column to Variable< 1 %Table Column to Variable< 1 %Database Update< 1 %Loop End< 1 %Variable Condition Loop End< 1 %Cell Splitter< 1 %- Column Rename (Regex)< 1 %
- Pivot< 1 %
- Rule-based Row Filter< 1 %
- Rule Engine< 1 %
CASE Switch Data (End)< 1 %- Capture Workflow Start< 1 %
- Counter Generation< 1 %
XLS Writer< 1 %- Container Output (Row)< 1 %
- Kafka Producer< 1 %
MongoDB Reader< 1 %- Data to Report (BIRT)< 1 %
- String to Date/Time (legacy)< 1 %
- Neo4j Reader< 1 %
- Collection to String< 1 %
- URL to File Path< 1 %
- Wait...< 1 %
- Catch Errors (Data Ports)< 1 %
- Table Column to Variable< 1 %
Table Row to Variable< 1 %Table Row To Variable Loop Start< 1 %- Read Images< 1 %
Database Writer< 1 %- Java Edit Variable< 1 %
- Variable Condition Loop End< 1 %
Generic Loop Start< 1 %Recursive Loop End< 1 %- RProp MLP Learner< 1 %
- SVM Learner< 1 %
- Column Comparator< 1 %
Number To String< 1 %- String to Number< 1 %
Column Appender< 1 %- Column Merger< 1 %
- Table Validator (Reference)< 1 %
- Filter Apply Row Splitter< 1 %
- Nominal Value Row Filter< 1 %
- Nominal Value Row Splitter< 1 %
- Reference Row Filter< 1 %
- Missing Value< 1 %
- Row Sampling< 1 %
- Sorter< 1 %
String Replace (Dictionary)< 1 %- Top k Row Filter< 1 %
- Table Transposer< 1 %
- Unpivot< 1 %
- Data Explorer< 1 %
- Independent groups t-test< 1 %
- IF Switch< 1 %
- Cache< 1 %
- Histogram (legacy)< 1 %
- Interactive Pie chart (legacy)< 1 %
- Color Manager< 1 %
- Interactive Table (legacy)< 1 %
- DB Insert< 1 %
- DB Writer< 1 %
DB Table Creator< 1 %- Math Formula< 1 %
Excel Writer (XLS)< 1 %- SMB Connector< 1 %
- Java Edit Variable (simple)< 1 %
- Java IF (Table)< 1 %
- Chi-Square Keyword Extractor< 1 %
- Bag Of Words Creator< 1 %
- Table View (JavaScript)< 1 %
- Line Plot (JavaScript)< 1 %
JSON Path< 1 %MongoDB Remove< 1 %MongoDB Update< 1 %- MongoDB Save< 1 %
- MongoDB Update< 1 %
Python Script (1⇒1)< 1 %- DELETE Request< 1 %
- String to Date&Time< 1 %
- Column to XML< 1 %
Location Extractor< 1 %Reverse Location Lookup< 1 %- HTTP Retriever< 1 %
Views
- This node has no views
Workflows
_Predictor_FlowKNIME Hub
00_xplan sf dbconv-insert via xport-AccountKNIME Hub
01_xplan sf dbconv-insert via csv-AddressKNIME Hub- 01_xplan sf dbconv-insert via xport-AddressKNIME Hub
- 04-Add-Documents-to-ElasticsearchNodePit
- Show all 97 workflows
Links
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.