Converts a JSON column to multiple columns, whereby the column list is heuristically extracted from the
JSON structure. It can either extract the primitive leaf elements (like strings and numbers), omitting the
JSON tree path, or the full JSON structure. The latter, however, may yield some confusing output as the types
of the columns are again JSON or collections of JSON.
Note that this node is meant to be used for "well-structured", relatively flat JSON objects which adhere the
same schema in all rows. In case the JSON objects are more complex it's better to use nodes like
JSON Path or JSON Path (Dictionary).
Some examples on the following JSON column input may help to clarify the generated output.
| JSON |
|---|
| {"a": {"b": [1, 2], "c":"c"}} |
| {"a": {"b": [3], "d":null} } |
Types:
- b - JSON when Keep as JSON array, list of integers when Keep as collection elements
- c - String
- d - String
| b | c | d |
|---|---|---|
| [1,2] | c | ? |
| [3] | ? | ? |
1, Use leaf name (uniquify with (#1)/(#2)/...)Type: a - JSON
| a |
|---|
| {"b": [1, 2], "c":"c"} |
| {"b": [3], "d":null} |
., Expand to columnsType:
- a.b.0, a.b.1 - integer
- a.c, a.d - string
| a.b.0 | a.b.1 | a.c | a.d |
|---|---|---|---|
| 1 | 2 | c | ? |
| 3 | ? | ? | ? |
| JSON |
|---|
| {"a":[{"b": 3}, 4]} |
| {"a":[1]} |
1, Use leaf name (uniquify with (#1)/(#2)/...), Omit nested objects, Expand to columns:Type:
- a - list of integers
| a |
|---|
| [4] |
| [1] |
1 or 2, Use leaf name (uniquify with (#1)/(#2)/...), do not Omit nested objects, Expand to columns:Type:
- a - list of JSON values
| a |
|---|
| [{"b": 3}, 4] |
| [1] |
{"b": 3} and 4, not a single JSON value, similarly in the second row, you get a KNIME list of a single JSON value: 1.
Though with Keep as JSON array (regardless of Omit nested objects):
Type:
- a - JSON values
| a |
|---|
| [{"b": 3}, 4] |
| [1] |
Options
Popular Successors
- Column Filter11 %
- Joiner5 %
Table Row to Variable4 %- Ungroup4 %
Row Filter (deprecated)3 %- String Manipulation2 %
- Table Transposer2 %
Column Rename2 %- JSON Path2 %
- JSON to Table2 %
- Excel Writer2 %
- GroupBy1 %
- Loop End1 %
- Unpivot1 %
- CSV Writer1 %
Column Appender1 %- Rule-based Row Filter< 1 %
String To Number< 1 %- Column Expressions< 1 %
- Table Manipulator< 1 %
- Duplicate Row Filter< 1 %
- Table to JSON< 1 %
- Concatenate< 1 %
- Rule Engine< 1 %
- One Row to Many< 1 %
- JSON Transformer< 1 %
- Cell Splitter< 1 %
PMML Predictor< 1 %- Constant Value Column< 1 %
Table to PDF< 1 %- Table View (JavaScript)< 1 %
MongoDB Writer< 1 %Concatenate (Optional in)< 1 %- JSON Row Combiner< 1 %
Row Splitter (deprecated)< 1 %- Value Lookup< 1 %
- Empty Table Switch< 1 %
- GET Request< 1 %
- String to Number< 1 %
- Column Rename (Regex)< 1 %
- Pivot< 1 %
- RowID< 1 %
- Table View< 1 %
- Split Collection Column< 1 %
- Group Loop Start< 1 %
- Cross Joiner< 1 %
- Column Splitter< 1 %
- DB Writer< 1 %
XLS Writer< 1 %- Column to XML< 1 %
- Binary Objects to PNGs< 1 %
- k-Means< 1 %
CASE Switch Data (End)< 1 %- JSON to XML< 1 %
- Column to Grid< 1 %
- Missing Value< 1 %
- External Tool< 1 %
- JSON Row Combiner and Writer< 1 %
- Sorter< 1 %
- Top k Row Filter< 1 %
- Counter Generation< 1 %
Table to HTML< 1 %- Column Filter (legacy)< 1 %
CSV Writer< 1 %- Column Name Extractor< 1 %
- Partitioning< 1 %
- Statistics< 1 %
- Line Plot (legacy)< 1 %
- JSON Writer< 1 %
- Container Output (JSON)< 1 %
- String to Date&Time< 1 %
- Table Writer< 1 %
- Java Snippet< 1 %
Cell Replacer< 1 %Number To String< 1 %- Column Aggregator< 1 %
- Reference Row Filter< 1 %
- Sunburst Chart (JavaScript)< 1 %
- Math Formula< 1 %
- RegEx Filter< 1 %
- Strings to Document< 1 %
- JSON Column Combiner< 1 %
- Container Input (Row)< 1 %
- Table Column to Variable< 1 %
- Chunk Loop Start< 1 %
- Decision Tree Predictor< 1 %
Random Forest Predictor< 1 %- Column Renamer< 1 %
- Column Appender< 1 %
- Column Resorter< 1 %
- String Manipulation (Multi Column)< 1 %
- IF Switch< 1 %
- Capture Workflow End< 1 %
- Column Filter Configuration< 1 %
- XML to JSON< 1 %
- POST Request< 1 %
Map Viewer< 1 %- Coordinate to Latitude/Longitude< 1 %
- Collection to String< 1 %
- Table Row to Variable< 1 %
- Generic Loop Start< 1 %
Variable Loop End< 1 %- Column Renamer (Dictionary)< 1 %
- Constant Value Column Filter< 1 %
- Reference Row Splitter< 1 %
- Reference Column Resorter< 1 %
- Value Counter< 1 %
- CASE Switch End< 1 %
- Histogram (legacy)< 1 %
- Java Snippet (simple)< 1 %
Tableau Writer (Hyper)< 1 %- Tableau Writer< 1 %
- Columns to JSON< 1 %
- Kafka Producer< 1 %
- MongoDB Connector< 1 %
- MongoDB Remove< 1 %
- XPath< 1 %
- XSLT< 1 %
- Compiled Model Predictor< 1 %
- Configurable IF/CASE Switch (Flow Variable Value)< 1 %
- Strings to Binary Objects< 1 %
- Catch Errors (Data Ports)< 1 %
- Try (Data Ports)< 1 %
Variable to Table Column< 1 %- Variable to Table Column< 1 %
- Read Images< 1 %
- Table Reader< 1 %
Loop End< 1 %- Recursive Loop End< 1 %
Recursive Loop End< 1 %- Column Combiner< 1 %
- One to Many< 1 %
Linear Correlation< 1 %- Reference Column Filter< 1 %
- Filter Apply< 1 %
- Filter Apply Row Splitter< 1 %
- Missing Value Column Filter< 1 %
- Nominal Value Row Filter< 1 %
String Replace (Dictionary)< 1 %- Rule-based Row Splitter< 1 %
- CASE Switch Start< 1 %
- Cache< 1 %
- Timer Info< 1 %
- Color Manager< 1 %
- Table to Spark< 1 %
- Molecule Type Cast< 1 %
- Parallel Chunk End< 1 %
DB Table Creator< 1 %- Table Editor (JavaScript)< 1 %
- JSON Diff< 1 %
- JSON Schema Validator< 1 %
- MongoDB Save< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Call Workflow Service< 1 %
- Neo4j Writer< 1 %
- Base64 Decoder< 1 %
- HTTP Retriever< 1 %
- HTML Parser< 1 %
- Set To List< 1 %
- Create Collection Column< 1 %
- Binary Objects to Strings< 1 %
- String to URI< 1 %
- Wait...< 1 %
- Inject Variables (Data)< 1 %
Table Row to Variable< 1 %Variable to Table Row< 1 %- Table Creator< 1 %
- Loop End (Column Append)< 1 %
- Column List Loop Start< 1 %
- Variable Condition Loop End< 1 %
- Recursive Loop Start< 1 %
- Variable Loop End< 1 %
- Table Row to Variable Loop Start< 1 %
Tree Ensemble Predictor< 1 %- Case Converter< 1 %
- Cell Splitter By Position< 1 %
- Column Auto Type Cast< 1 %
- Number to String< 1 %
- Lag Column< 1 %
- Column Merger< 1 %
- Many to One< 1 %
- Table Validator< 1 %
- Domain Calculator< 1 %
- Nominal Value Row Splitter< 1 %
Joiner< 1 %- Denormalizer< 1 %
- String Splitter (Regex)< 1 %
- Row to Column Names< 1 %
- String Manipulation (Variable)< 1 %
- String Replacer< 1 %
- Table Difference Finder< 1 %
- Rule Engine (Dictionary)< 1 %
- Data Explorer< 1 %
- End IF< 1 %
- Extract Table Dimension< 1 %
- Extract Table Spec< 1 %
- Interactive Table (legacy)< 1 %
- Bar Chart< 1 %
- Parquet Writer< 1 %
- DB Insert< 1 %
- DB Table Creator< 1 %
- Model Loop Start< 1 %
- Math Formula (Multi Column)< 1 %
- OSM Map View< 1 %
Excel Sheet Appender (XLS)< 1 %Excel Writer (XLS)< 1 %- Send to Power BI< 1 %
Document Data Extractor< 1 %- Path to URI< 1 %
- String to Path< 1 %
- Transfer Files< 1 %
- Google Sheets Updater< 1 %
- Line Plot (JavaScript)< 1 %
- String to JSON< 1 %
- JSON Path (Dictionary)< 1 %
MongoDB Remove< 1 %- MongoDB Writer< 1 %
- Python Script (legacy)< 1 %
- Data to Report (BIRT)< 1 %
- Date&Time Difference< 1 %
- Workflow Service Input< 1 %
Regex Extractor< 1 %Table Column to Variable< 1 %Database Update< 1 %- Feature Selection Loop Start (1:1)< 1 %
Loop End (2 ports)< 1 %Interval Loop Start< 1 %Variable Condition Loop End< 1 %- Tree Ensemble Predictor< 1 %
- Column Filter (PMML)< 1 %
- XML to PMML< 1 %
Parquet Writer< 1 %- H2O MOJO Predictor (Classification)< 1 %
- H2O MOJO Predictor (Regression)< 1 %
Microsoft Authenticator (Deprecated)< 1 %- Topic Extractor (Parallel LDA)< 1 %
- Generic JavaScript View (JavaScript)< 1 %
- Container Input (Table)< 1 %
Extract Date&Time Fields< 1 %- Date&Time-based Row Filter< 1 %
- Append to Collection< 1 %
- Coordinate Row Filter< 1 %
Binary Objects to Files< 1 %- URL to File Path< 1 %
Table Column to Variable< 1 %Naive Bayes Learner< 1 %- Decision Tree Learner< 1 %
PCA< 1 %- Add Empty Rows< 1 %
- Auto-Binner (Apply)< 1 %
- Column Comparator< 1 %
- Row Filter (Labs)< 1 %
- Normalizer< 1 %
- Row Sampling< 1 %
CASE Switch Data (Start)< 1 %- Autocomplete Text Widget< 1 %
- GroupBy Bar Chart (JFreeChart)< 1 %
- Java IF (Table)< 1 %
- Punctuation Erasure< 1 %
- Path to String< 1 %
- Container Output (Table)< 1 %
- Data Row to Image< 1 %
- Row to Network< 1 %
- Python View (legacy)< 1 %
- R Snippet< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Date&Time Shift< 1 %
- Molecule to CDK< 1 %
- RDKit From InChI< 1 %
- Find MIME-Type< 1 %
- URI to String< 1 %
- Catch Errors (Generic Ports)< 1 %
- Extract Variables (Data)< 1 %
- Table to Image< 1 %
Parameterized Database Query< 1 %- Image Writer (Table)< 1 %
File Reader< 1 %Counting Loop Start< 1 %Generic Loop Start< 1 %Recursive Loop End (2 ports)< 1 %Recursive Loop Start< 1 %- SOTA Learner< 1 %
- Random Forest Predictor (Regression)< 1 %
- Auto-Binner< 1 %
- String to SVG< 1 %
- Reference Column Splitter< 1 %
String To Number (PMML)< 1 %- Rule-based Row Filter (Dictionary)< 1 %
CASE Switch Variable (Start)< 1 %- Parallel Chunk Start< 1 %
- Microsoft SQL Server Connector< 1 %
- DB Merge< 1 %
- Random Number Assigner< 1 %
- Numeric Distances< 1 %
- Similarity Search< 1 %
- Prediction Fusion< 1 %
- Generic Web Service Client< 1 %
- Line Chart (JFreeChart)< 1 %
- OSM Map to Image< 1 %
Excel Writer (XLS)< 1 %- Java Snippet Row Filter< 1 %
POS tagger< 1 %Bag of Words Creator< 1 %- String to Term< 1 %
- Value Filter (legacy)< 1 %
- Scorer (JavaScript)< 1 %
JSON Writer< 1 %Python Script (1⇒1)< 1 %- Table to R< 1 %
- PUT Request< 1 %
- Modify Time< 1 %
- Date/Time Shift (legacy)< 1 %
- Date Field Extractor (legacy)< 1 %
- Twitter Followers Search< 1 %
- XGBoost Predictor< 1 %
- XML Column Combiner< 1 %
- CDK to Molecule< 1 %
Spacy Tokenizer< 1 %- Text Classifier Predictor< 1 %
- HTML Node to Text< 1 %
Find Elements< 1 %- TableToFile< 1 %
- Fingerprint From Set Bits list< 1 %
Flow Variable IF Switch< 1 %- Generic Run-for-time Loop Start< 1 %
- Table Row To Variable Run-to-time Loop Start< 1 %
- List To Set< 1 %
- Collection Size< 1 %
- URL Decode< 1 %
- URL Encode< 1 %
- MolConverter< 1 %
- String to Table< 1 %
- Table to String< 1 %
Element Selector< 1 %- ARIMA Learner< 1 %
- Copy/Move Files (legacy)< 1 %
- Download / Upload from List (legacy)< 1 %
- Extract URI Info< 1 %
- File Meta Info (legacy)< 1 %
- URL to File Path (Variable)< 1 %
- Breakpoint< 1 %
- Active Branch Inverter< 1 %
Variable to Table Column< 1 %Table Column to Variable< 1 %Table Row To Variable Loop Start< 1 %Image Writer (Table Column)< 1 %- ARFF Writer< 1 %
Database Writer< 1 %Database Table Creator< 1 %Table Writer< 1 %Recursive Loop Start (2 ports)< 1 %Naive Bayes Predictor< 1 %- Cluster Assigner< 1 %
- Fuzzy c-Means< 1 %
- Hierarchical Clustering< 1 %
- MultiLayerPerceptron Predictor< 1 %
- RProp MLP Learner< 1 %
- Linear Regression Learner< 1 %
- Logistic Regression Predictor< 1 %
Regression Predictor< 1 %- Regression Predictor< 1 %
Scorer< 1 %- Numeric Scorer< 1 %
- SOTA Predictor< 1 %
- SVM Learner< 1 %
- Gradient Boosted Trees Predictor (Regression)< 1 %
Tree Ensemble Learner< 1 %- Tree Ensemble Predictor (Regression)< 1 %
- Random Forest Learner< 1 %
- Random Forest Predictor< 1 %
- Simple Regression Tree Predictor< 1 %
Cell Splitter< 1 %- Linear Correlation< 1 %
- Correlation Filter< 1 %
- Interactive HiLite Collector< 1 %
- Row Splitter (Labs)< 1 %
- Key-Collection HiLite Translator< 1 %
- Subset Matcher< 1 %
- Many to One (PMML)< 1 %
- Normalizer Apply (PMML)< 1 %
- String to Number (PMML)< 1 %
- Nominal Probability Distribution Splitter< 1 %
- Rank< 1 %
- Number Rounder< 1 %
- Numeric Row Splitter< 1 %
- Set Operator< 1 %
- Renderer to Image< 1 %
- Rule Engine Variable< 1 %
- Bland-Altman Plot< 1 %
Rank Correlation< 1 %- Send Email< 1 %
- Conditional Box Plot (legacy)< 1 %
- Crosstab< 1 %
- HiLite Table (legacy)< 1 %
- Interactive Histogram (legacy)< 1 %
- Interactive Pie chart (legacy)< 1 %
- Box Plot (legacy)< 1 %
- Scatter Plot (legacy)< 1 %
- Scatter Matrix (legacy)< 1 %
Color Appender< 1 %- Shape Manager< 1 %
- Size Manager< 1 %
- PMML Compiling Predictor< 1 %
Parquet Writer< 1 %Hive Loader (legacy)< 1 %- SDF Extractor< 1 %
- Amazon Comprehend (Sentiment)< 1 %
- Amazon Comprehend (Entity Tagger)< 1 %
- DB Connector< 1 %
- DB Loader< 1 %
- Parameterized DB Query Reader< 1 %
- DB Update< 1 %
- DB Table Remover< 1 %
- TimeDelay Loop Start< 1 %
- Matrix Distance< 1 %
- Distance Matrix Calculate< 1 %
- Keras Network Executor< 1 %
- Histogram (JavaScript)< 1 %
- Pie/Donut Chart (JavaScript)< 1 %
- PMML Predictor< 1 %
- Cell to PMML< 1 %
- Table to PDF (legacy)< 1 %
- OpenBabel< 1 %
- DL4J Feedforward Learner (Classification) (legacy)< 1 %
- Table to H2O< 1 %
- Scatter Plot (JFreeChart)< 1 %
- Table Indexer< 1 %
- Geo-Coordinate Row Filter< 1 %
Excel Sheet Appender (XLS)< 1 %Send to Power BI< 1 %- Spark Line Appender< 1 %
Send to Tableau Server (Hyper)< 1 %- Word Vector Apply (legacy)< 1 %
- Markup Tag Filter< 1 %
- Case Converter< 1 %
- Number Filter< 1 %
Stop Word Filter< 1 %- Stop Word Filter< 1 %
RSS Feed Reader< 1 %- Dictionary Tagger< 1 %
- Bag Of Words Creator< 1 %
Strings To Document< 1 %- Document Viewer< 1 %
- External Tool (Labs)< 1 %
- JPMML Regression Predictor< 1 %
- Column Selection Configuration< 1 %
- Value Selection Configuration< 1 %
- CSS Editor< 1 %
- Column Selection (legacy)< 1 %
- Value Selection (legacy)< 1 %
- ROC Curve (JavaScript)< 1 %
- Scatter Plot (JavaScript)< 1 %
- Tag Cloud (JavaScript)< 1 %
- Tile View (JavaScript)< 1 %
- Interactive Value Filter Widget< 1 %
- Tile Loop Start< 1 %
MongoDB Update< 1 %- MongoDB Reader< 1 %
- Feature Inserter< 1 %
- Object Inserter< 1 %
Python Script (1⇒1)< 1 %Python Script (2⇒1)< 1 %- Python Source (legacy)< 1 %
- R Predictor< 1 %
- Webpage Retriever< 1 %
- Table Difference Checker< 1 %
- Date&Time to String< 1 %
- Create Date&Time Range< 1 %
- Date&Time Part Extractor< 1 %
- Modify Date< 1 %
- Moving Aggregator< 1 %
- String to Date/Time (legacy)< 1 %
Table to HTML String< 1 %- Table to HTML String< 1 %
- RDKit Descriptor Calculation< 1 %
- RDKit Interactive Table< 1 %
- RDKit From Molecule< 1 %
- RDKit Fingerprint< 1 %
- MapQuest Geocoder< 1 %
- Latitude/Longitude to Coordinate< 1 %
- Hash Calculator< 1 %
- URL Domain Extractor< 1 %
- Form Encoded HTTP Entity Creator< 1 %
- Navigate< 1 %
Table Extractor< 1 %
Views
- This node has no views
Workflows
_01_TestWF_Fails_Then_SucceedsKNIME Hub- _Predictor_FlowKNIME Hub
- 0. TemplatesKNIME Hub
00_xplan sf dbconv-insert via xport-AccountKNIME Hub- 01_Access_data_from_NoSQL_DB_and_PDFs - SolutionKNIME Hub
- Show all 545 workflows
Links
- JSON to Tableby armingrudd on 2019-04-24forum.knime.com/p/59303
- GET Request Node Help (newbie)by JanDuo on 2020-07-21forum.knime.com/p/97506
- XML to CSV / Table conversion without using XPathby qqilihq on 2021-05-28forum.knime.com/p/124933
- XML to CSV / Table conversion without using XPathby qqilihq on 2021-05-28forum.knime.com/p/124939
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.