Converts the selected columns content to a JSON value row-wise or column-wise. It also has an option to "undo" - with some limitations - the JSON to Table transformation, and can create JSON values for each row based on the column names.
Example input table:
| a.b | a.c | d |
|---|---|---|
| b0 | c0 | d0 |
| b1 | c1 | d1 |
Row-oriented (datatable as one JSON value):
[ {
"a.b" : "b0",
"a.c" : "c0",
"d" : "d0"
}, {
"a.b" : "b1",
"a.c" : "c1",
"d" : "d1"
} ]
Keep rows (column names treated as paths, default separator: .):
{
"a" : {
"b" : "b0",
"c" : "c0"
},
"d" : "d0"
}
{
"a" : {
"b" : "b1",
"c" : "c1"
},
"d" : "d1"
}
Column-oriented (row keys as JSON value, with the key: "ROWID"):
{
"ROWID" : [ "Row0", "Row1" ],
"a.b" : [ "b0", "b1" ],
"a.c" : [ "c0", "c1" ],
"d" : [ "d0", "d1" ]
}Options
Popular Successors
- JSON Writer4 %
- POST Request3 %
- JSON Path2 %
Table Writer2 %MongoDB Writer2 %Loop End1 %- RowID1 %
Table Row To Variable Loop Start1 %Table Column to Variable< 1 %- Columns to JSON< 1 %
Variable to Table Column< 1 %CSV Writer< 1 %- String Manipulation< 1 %
- JSON to XML< 1 %
- Python View (legacy)< 1 %
- Workflow Output< 1 %
- Call Workflow Service< 1 %
Table Row to Variable< 1 %- CSV Writer< 1 %
- Reference Column Filter< 1 %
Call Local Workflow (Row Based)< 1 %- Loop End< 1 %
- Cell Splitter< 1 %
Joiner< 1 %- Pivot< 1 %
- Table Transposer< 1 %
- Rule-based Row Filter< 1 %
Excel Writer (XLS)< 1 %- Container Output (Table)< 1 %
- JSON Transformer< 1 %
- JSON to Table< 1 %
- Kafka Producer< 1 %
- MongoDB Remove< 1 %
- MongoDB Save< 1 %
- XPath< 1 %
- Compiled Model Predictor< 1 %
- Variable to Table Column< 1 %
Table Row to Variable< 1 %- Table Row to Variable< 1 %
- Table Row to Variable Loop Start< 1 %
Variable Loop End< 1 %- Concatenate< 1 %
- Column Renamer (Dictionary)< 1 %
Constant Value Column< 1 %- Table Manipulator< 1 %
- String Manipulation (Variable)< 1 %
- End IF< 1 %
- Interactive Table (legacy)< 1 %
- Parallel Chunk Start< 1 %
- Excel Writer< 1 %
- Java Snippet (simple)< 1 %
- JSON Row Combiner< 1 %
- String to JSON< 1 %
- Table to JSON< 1 %
- MongoDB Connector< 1 %
- GET Request< 1 %
- Set To List< 1 %
- Columns to Collection< 1 %
- Binary Objects to Files< 1 %
Binary Objects to Files< 1 %- Catch Errors (Data Ports)< 1 %
- Table Column to Variable< 1 %
- Table Writer< 1 %
- Java Snippet< 1 %
- Chunk Loop Start< 1 %
Generic Loop Start< 1 %- Group Loop Start< 1 %
- Column Appender< 1 %
- Column Resorter< 1 %
- Cross Joiner< 1 %
- Column Filter< 1 %
Row Filter (deprecated)< 1 %- GroupBy< 1 %
- Joiner< 1 %
- Table Partitioner< 1 %
- Missing Value< 1 %
Column Rename< 1 %- Row Sampler< 1 %
- String Manipulation (Multi Column)< 1 %
- String Replacer< 1 %
- Top k Row Filter< 1 %
- Ungroup< 1 %
- Rule Engine< 1 %
- CASE Switch End< 1 %
- Capture Workflow End< 1 %
DB Insert< 1 %DB Writer< 1 %- Column Expressions (legacy)< 1 %
- HeatMap (JFreeChart)< 1 %
- Send to Power BI< 1 %
- Generic JavaScript View (JavaScript) (legacy)< 1 %
- Table View (JavaScript) (legacy)< 1 %
- JSON Column Combiner< 1 %
- JSON Row Combiner and Writer< 1 %
- JSON Path (Dictionary)< 1 %
- Container Output (JSON)< 1 %
- JSON Schema Validator< 1 %
JSON Writer< 1 %- MongoDB Update< 1 %
- MongoDB Writer< 1 %
- Python Script (legacy)< 1 %
- Data to Report (BIRT)< 1 %
- PATCH Request< 1 %
- PUT Request< 1 %
- Call Workflow (Row Based)< 1 %
- Call Workflow (Table Based)< 1 %
- HTTP Retriever< 1 %
Database Update< 1 %- Constant Value Row Appender< 1 %
- Column Auto Type Cast< 1 %
Column Appender< 1 %- Subset Matcher< 1 %
- JSON Diff< 1 %
JSON Reader< 1 %Python Script (1⇒1)< 1 %- Strings to Binary Objects< 1 %
- Wait...< 1 %
- Try (Data Ports)< 1 %
- Inject Variables (Data)< 1 %
- Java Edit Variable< 1 %
- Recursive Loop End< 1 %
- Variable Loop End< 1 %
- Hierarchical Clustering (DistMatrix)< 1 %
String To Number< 1 %- Reference Row Filter< 1 %
- Rank< 1 %
- Send Email< 1 %
- Pie chart (legacy)< 1 %
Parquet Writer< 1 %- Weka Predictor (3.7)< 1 %
- Line Plot (JavaScript) (legacy)< 1 %
Variable to Table Column< 1 %- Loop End (Column Append)< 1 %
- Column List Loop Start< 1 %
Variable Condition Loop End< 1 %- Decision Tree Predictor< 1 %
Cell Replacer< 1 %- Column Combiner< 1 %
- Number to String< 1 %
- Constant Value Column Filter< 1 %
- Missing Value Column Filter< 1 %
- Sorter< 1 %
Column Splitter< 1 %- Unpivot< 1 %
CASE Switch Data (End)< 1 %- IF Switch< 1 %
- Cache< 1 %
- Extract Table Dimension< 1 %
- HiLite Table (legacy)< 1 %
- Interactive Histogram (legacy)< 1 %
- Workflow Executor< 1 %
- Parallel Chunk End< 1 %
- Math Formula< 1 %
- Java IF (Table)< 1 %
- Spark Line Appender< 1 %
- Shapefile writer< 1 %
- File Download (legacy)< 1 %
MongoDB Remove< 1 %MongoDB Update< 1 %Python Script (2⇒2)< 1 %- R Snippet< 1 %
- Fail in execution< 1 %
- Form Encoded HTTP Entity Creator< 1 %
- TableToFile< 1 %
- Message Slack channel< 1 %
Python Snippet< 1 %Copy/Move Files< 1 %File Meta Info< 1 %Upload< 1 %- Breakpoint< 1 %
Table Column to Variable< 1 %Database Writer< 1 %Parameterized Database Query< 1 %Extract Context Properties< 1 %- Table Creator< 1 %
Loop End (2 ports)< 1 %Counting Loop Start< 1 %Interval Loop Start< 1 %Recursive Loop End< 1 %Recursive Loop Start< 1 %- Random Forest Learner (Regression)< 1 %
Concatenate (Optional in)< 1 %Auto-Binner< 1 %- Create Byte Vector< 1 %
Cell Splitter< 1 %Number To String< 1 %- String to SVG< 1 %
- Column Aggregator< 1 %
- Column Name Extractor< 1 %
- Column Name Replacer< 1 %
- Table Validator< 1 %
- Domain Calculator< 1 %
- Table Difference Finder< 1 %
- Value Counter< 1 %
- Data Explorer< 1 %
Merge Variables< 1 %- Timer Info< 1 %
- Enrichment Plotter (legacy)< 1 %
- Histogram (legacy)< 1 %
- Interactive Pie chart (legacy)< 1 %
- Scatter Plot (legacy)< 1 %
- Save Workflow< 1 %
- Table to Spark< 1 %
DB Delete (Table)< 1 %DB Merge< 1 %DB Table Creator< 1 %- PMML Predictor< 1 %
Table to HTML< 1 %- Table to PDF (legacy)< 1 %
- Generic Web Service Client< 1 %
- Math Formula (Multi Column)< 1 %
- Table Indexer< 1 %
- OSM Map to Image< 1 %
- OSM Map View< 1 %
Send to Power BI< 1 %- Java Snippet Row Splitter< 1 %
- Chi-Square Keyword Extractor< 1 %
- String Matcher< 1 %
- Strings to Document< 1 %
- String to Term< 1 %
- Document Viewer< 1 %
- Distance< 1 %
- Text Output (legacy)< 1 %
- Decision Tree View (JavaScript) (legacy)< 1 %
- Scatter Plot (JavaScript) (legacy)< 1 %
- Container Input (Table)< 1 %
- Container Output (Row)< 1 %
JSON Path< 1 %MongoDB Save< 1 %- Matrix to Network< 1 %
Python Script (1⇒1)< 1 %Python Script (2⇒1)< 1 %- Table to R< 1 %
String to Date&Time< 1 %- Time Generator (legacy)< 1 %
- Preset Date/Time (legacy)< 1 %
XML Writer< 1 %- Discretise< 1 %
- Neo4j Reader< 1 %
- Neo4j Writer< 1 %
- HTML Parser< 1 %
- Multipart Encoded HTTP Entity Creator< 1 %
Views
- This node has no views
Workflows
_01_TestWF_Fails_Then_SucceedsKNIME Hub- 00_call_local_workflow_(JSON)KNIME Hub
- 00_check_prime_numberKNIME Hub
- 00_Topic_Modeling_with_Verified_ComponentsKNIME Hub
- 00_Topic_Modeling_with_Verified_ComponentsKNIME Hub
- Show all 538 workflows
Links
- Flow_variables to support Object as wellby izaychik63 on 2020-08-11forum.knime.com/p/99623
- String manipulation for requests bodyby danielesser on 2020-11-15forum.knime.com/p/108268
- Pulling Row Data into JSON Content Bodyby qqilihq on 2022-05-07forum.knime.com/p/156188
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.