Converts the selected columns content to a JSON value row-wise or column-wise. It also have an option to "undo" -with some limitations- the JSON to Table transformation and 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
[ {
"a.b" : "b0",
"a.c" : "c0",
"d" : "d0"
}, {
"a.b" : "b1",
"a.c" : "c1",
"d" : "d1"
} ]
Column-oriented (with Row keys as JSON value with key: "ROWID"):
{
"ROWID" : [ "Row0", "Row1" ],
"a.b" : [ "b0", "b1" ],
"a.c" : [ "c0", "c1" ],
"d" : [ "d0", "d1" ]
}
Keep rows (with Column names as paths, separator: .):
{
"a" : {
"b" : "b0",
"c" : "c0"
},
"d" : "d0"
}
{
"a" : {
"b" : "b1",
"c" : "c1"
},
"d" : "d1"
}Options
Popular Predecessors
- Table Creator4 %
Column Rename4 %- Column Filter3 %
Row Filter (deprecated)3 %- String Manipulation3 %
- GroupBy3 %
Variable to Table Row2 %Column Appender2 %- Concatenate2 %
- Joiner2 %
- Column Expressions2 %
Variable to Table Column2 %- Constant Value Column2 %
- Column Resorter2 %
- Table to JSON1 %
- Domain Calculator1 %
- Column Renamer1 %
- Excel Reader1 %
- Column Appender1 %
- JSON to Table1 %
- String Manipulation (Multi Column)1 %
- CSV Reader< 1 %
- Chunk Loop Start< 1 %
- Group Loop Start< 1 %
Python Script (1⇒1)< 1 %- Cross Joiner< 1 %
- Missing Value< 1 %
- Duplicate Row Filter< 1 %
- Value Counter< 1 %
Database Connection Table Reader< 1 %- Columns to JSON< 1 %
- Loop End< 1 %
- CASE Switch End< 1 %
- JSON Path< 1 %
- String to Number< 1 %
Concatenate (Optional in)< 1 %- MongoDB Remove< 1 %
Number To String< 1 %- Sorter< 1 %
Excel Reader (XLS)< 1 %- Rule Engine< 1 %
- Rule-based Row Filter< 1 %
- String to Date&Time< 1 %
- Table Manipulator< 1 %
PMML Predictor< 1 %- Math Formula< 1 %
File Reader< 1 %- GET Request< 1 %
- CSV Writer< 1 %
- Container Input (Table)< 1 %
- String to JSON< 1 %
- JSON Column Combiner< 1 %
- File Meta Info (legacy)< 1 %
Table Row To Variable Loop Start< 1 %- Column Rename (Regex)< 1 %
- Reference Row Filter< 1 %
- Unpivot< 1 %
- DB Query Reader< 1 %
Excel Reader (XLS)< 1 %- Variable Loop End< 1 %
String To Number< 1 %- Ungroup< 1 %
Variable to Table Column< 1 %- Container Output (Table)< 1 %
- Twitter Timeline< 1 %
- Path to String< 1 %
- Catch Errors (Data Ports)< 1 %
Cell Splitter< 1 %- Column Splitter< 1 %
- Table Transposer< 1 %
- Parallel Chunk Start< 1 %
- Empty Table Creator< 1 %
XLS Reader< 1 %- Java Snippet (simple)< 1 %
- JSON Row Combiner< 1 %
- Column Merger< 1 %
- Table Validator< 1 %
- Row Filter (Labs)< 1 %
- Single Selection Configuration< 1 %
- JSON Reader< 1 %
- Python Script (legacy)< 1 %
- Inject Variables (Data)< 1 %
List Files< 1 %- Loop End (Column Append)< 1 %
- Column List Loop Start< 1 %
Scorer< 1 %- Column Name Extractor< 1 %
- Row Sampling< 1 %
- XPath< 1 %
- Extract Table Spec< 1 %
- Python Source (legacy)< 1 %
- Table Column to Variable< 1 %
- Variable Creator< 1 %
- Linear Correlation< 1 %
- Counting Loop Start< 1 %
Variable Loop End< 1 %- Column Auto Type Cast< 1 %
- Column Aggregator< 1 %
- Column Renamer (Dictionary)< 1 %
Row Splitter (deprecated)< 1 %- RowID< 1 %
- String Replacer< 1 %
- Data Generator< 1 %
- R Snippet< 1 %
- Quit WebDriver< 1 %
Variable to Table Row< 1 %- Model to Cell< 1 %
- Math Formula (Multi Column)< 1 %
- Variable to Table Row< 1 %
- File Reader< 1 %
- H2O MOJO Predictor (Classification)< 1 %
- Row to Column Names< 1 %
- Create Collection Column< 1 %
- Binary Objects to Strings< 1 %
- Wait...< 1 %
Table Row to Variable< 1 %- Java Snippet< 1 %
Loop End< 1 %Recursive Loop End< 1 %- Decision Tree Predictor< 1 %
Cell Replacer< 1 %- Column Combiner< 1 %
Joiner< 1 %- Partitioning< 1 %
- Pivot< 1 %
- Number Rounder< 1 %
- Rule-based Row Splitter< 1 %
- Empty Table Switch< 1 %
- End IF< 1 %
- Color Manager< 1 %
- Column Filter (legacy)< 1 %
- Table View (JavaScript)< 1 %
- Container Input (JSON)< 1 %
- JSON Transformer< 1 %
Python Script (1⇒1)< 1 %- Twitter Search< 1 %
- Add Empty Rows< 1 %
- Cell Splitter< 1 %
- Number to String< 1 %
- Double to Integer< 1 %
- Nominal Value Row Filter< 1 %
- String Manipulation (Variable)< 1 %
String Replace (Dictionary)< 1 %- Top k Row Filter< 1 %
- IF Switch< 1 %
- Extract Table Dimension< 1 %
- DB Reader< 1 %
- Google Sheets Reader< 1 %
- Table Editor (JavaScript)< 1 %
MongoDB Reader< 1 %- POST Request< 1 %
- Date&Time to String< 1 %
- Date&Time to legacy Date&Time< 1 %
- RDKit Canon SMILES< 1 %
Extract Outer/InnerHTML< 1 %- Variable to Table Column< 1 %
- Table Row to Variable< 1 %
- Table Reader< 1 %
- Recursive Loop End< 1 %
- Table Row to Variable Loop Start< 1 %
- Scorer< 1 %
- DB Update< 1 %
- JSON Writer< 1 %
- MongoDB Reader< 1 %
- Salesforce SOQL< 1 %
- Date&Time Difference< 1 %
- Generic Loop Start< 1 %
Regex Extractor< 1 %- Excel Writer< 1 %
- Recursive Loop Start< 1 %
- String to URI< 1 %
Database Reader< 1 %Database Looping< 1 %- Java Edit Variable< 1 %
- Hierarchical Clustering< 1 %
- Reference Row Splitter< 1 %
- Rank< 1 %
CASE Switch Data (Start)< 1 %- Triple File Reader< 1 %
OAuth< 1 %Table Row to Variable< 1 %JSON Reader< 1 %- Merge Variables< 1 %
- String to XML< 1 %
CSV Reader< 1 %- Reference Column Resorter< 1 %
- Parallel Chunk End< 1 %
- Sentence Extractor< 1 %
- Test Data Generator< 1 %
- String to Date/Time (legacy)< 1 %
- Split Collection Column< 1 %
- PNGs to Binary Objects< 1 %
- Hierarchical Cluster Assigner< 1 %
- Random Forest Predictor< 1 %
- Ruleset Editor< 1 %
- H2O to Table< 1 %
- Shapefile reader< 1 %
- File Chooser (legacy)< 1 %
- Network to Row< 1 %
- Disturber Node< 1 %
- Date&Time-based Row Filter< 1 %
- Date&Time Shift< 1 %
- Column to XML< 1 %
- K Nearest Neighbor< 1 %
- TimeDelay Loop Start< 1 %
- Line Plot (JavaScript)< 1 %
- Breakpoint< 1 %
Table Reader< 1 %- Cluster Assigner< 1 %
- Linear Regression Learner< 1 %
- Table Validator (Reference)< 1 %
- Missing Value Column Filter< 1 %
- Renderer to Image< 1 %
CASE Switch Data (End)< 1 %- External Tool< 1 %
Excel Reader (XLS)< 1 %- Value Filter (legacy)< 1 %
Python Source< 1 %- R to Table< 1 %
- Time to String (legacy)< 1 %
- Twitter Retweet Search< 1 %
- HTTP Result Data Extractor< 1 %
Counting Loop Start< 1 %- Normalizer< 1 %
- Denormalizer (PMML)< 1 %
- Rule Engine (Dictionary)< 1 %
Parquet Reader< 1 %- PMML Predictor< 1 %
- Document Data Extractor< 1 %
- Latitude/Longitude to Coordinate< 1 %
- Try (Data Ports)< 1 %
- DB Connection Closer< 1 %
- DB Merge< 1 %
- Delete Files/Folders< 1 %
- List Box Input (legacy)< 1 %
- Multiple Selection Widget< 1 %
- Container Output (Row)< 1 %
- Compiled Model Predictor< 1 %
Flow Variable IF Switch< 1 %- URL to File Path< 1 %
Line Reader< 1 %Model Writer< 1 %Interval Loop Start< 1 %Numeric Scorer< 1 %- SMOTE< 1 %
Gradient Boosted Trees Predictor< 1 %- Simple Regression Tree Predictor< 1 %
- Cell Splitter By Position< 1 %
- Create Table Structure< 1 %
- Denormalizer< 1 %
CASE Switch Variable (Start)< 1 %Merge Variables< 1 %- Timer Info< 1 %
- ROC Curve (legacy)< 1 %
- DB Insert< 1 %
- Counter Generation< 1 %
Abner tagger< 1 %- Term to String< 1 %
- Google Analytics Query (legacy)< 1 %
- Multiple Selections (legacy)< 1 %
- XML to JSON< 1 %
Python Script (1⇒2)< 1 %Python Script (2⇒1)< 1 %- R Source (Table)< 1 %
- Get Git Commit Details< 1 %
- Create Date&Time Range< 1 %
- Time Generator (legacy)< 1 %
- Feed Parser< 1 %
- XLS Control Table Generator< 1 %
Loop End (3 ports)< 1 %- Chunk Loop Run-for-time Loop Start< 1 %
- Load Local PDB Files< 1 %
- Benchmark Start (2 ports)< 1 %
- Random Numbers Generator< 1 %
- URL Encode< 1 %
- Convert to Table< 1 %
- logD< 1 %
- MolConverter< 1 %
- List Audio Files< 1 %
- URL to File Path (Variable)< 1 %
Table Column to Variable< 1 %- Image to Table< 1 %
- CSV Array Reader< 1 %
CSV Writer< 1 %Line Reader< 1 %Loop End (2 ports)< 1 %Variable Condition Loop End< 1 %Generic Loop Start< 1 %Recursive Loop Start< 1 %- k-Means< 1 %
- Logistic Regression Predictor< 1 %
- Random Forest Predictor (Regression)< 1 %
- Case Converter< 1 %
- Column Comparator< 1 %
- Number to Category (Apply)< 1 %
- Column to Grid< 1 %
- Reference Column Filter< 1 %
- Filter Apply< 1 %
- Filter Apply Row Splitter< 1 %
- HiLite Row Splitter< 1 %
- Nominal Value Row Splitter< 1 %
- Missing Value (Apply)< 1 %
Number To String (PMML)< 1 %String To Number (PMML)< 1 %- Numeric Row Splitter< 1 %
- Shuffle< 1 %
- Ruleset Predictor< 1 %
- Data Explorer< 1 %
- Cache< 1 %
- Create Temp Dir (legacy)< 1 %
- Spark to Table< 1 %
- Molecule Type Cast< 1 %
- SDF Reader< 1 %
- DB Writer< 1 %
- DB Query Extractor< 1 %
- Gaussian Distributed Assigner< 1 %
- Random Number Assigner< 1 %
- Distance Matrix Calculate< 1 %
PMML Ensemble Predictor< 1 %- Explorer Browser< 1 %
- Association Rule Learner (Borgelt)< 1 %
- JPython Script 1:1 (Legacy)< 1 %
Read Excel Sheet Names (XLS)< 1 %Word Vector Apply (legacy)< 1 %- Keygraph Keyword Extractor< 1 %
- Stop Word Filter< 1 %
- Tika Parser< 1 %
- Bag Of Words Creator< 1 %
- Strings to Document< 1 %
- Tags to String< 1 %
- JPMML Cluster Assigner< 1 %
- Nominal Row Filter Configuration< 1 %
- Local File Browser Configuration< 1 %
- Container Input (Row)< 1 %
- Labeling Properties< 1 %
- Edge Table< 1 %
- Legacy Date&Time to Date&Time< 1 %
Extract Date&Time Fields< 1 %- Window Loop Start< 1 %
- Date/Time Shift (legacy)< 1 %
Table to HTML String< 1 %- Anonymization< 1 %
- Form Encoded HTTP Entity Creator< 1 %
- Find Elements< 1 %
- FileToTable< 1 %
- Collection to String< 1 %
- MzTabReader< 1 %
- Advanced MolConverter< 1 %
- Files to Binary Objects< 1 %
- List Remote Files (legacy)< 1 %
- File Reader (Complex Format)< 1 %
- Image Writer (Table)< 1 %
- Line Reader< 1 %
Table Writer< 1 %- Interval Loop Start< 1 %
- Variable Condition Loop End< 1 %
- Polynomial Regression Learner< 1 %
- Gradient Boosted Trees Predictor (Regression)< 1 %
- Extract Missing Value Cause< 1 %
- String Splitter (Regex)< 1 %
- Table Difference Finder< 1 %
- CASE Switch Start< 1 %
- Crosstab< 1 %
- Amazon Translate< 1 %
- DB Delete (Table)< 1 %
- Keras Network Executor< 1 %
- H2O MOJO Predictor (Regression)< 1 %
- SAS7BDAT Reader< 1 %
- Java Snippet Row Filter< 1 %
- Java Snippet Row Splitter< 1 %
- Topic Extractor (Parallel LDA)< 1 %
- Markup Tag Filter< 1 %
- Punctuation Erasure< 1 %
- Path to String (Variable)< 1 %
- String Configuration< 1 %
- String Widget< 1 %
- Webpage Retriever< 1 %
- Modify Date< 1 %
- Modify Time< 1 %
- Modify Time Zone< 1 %
- Moving Average< 1 %
- Hash Calculator< 1 %
Table Extractor< 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 385 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.