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 Predecessors
- JSON Reader9 %
- String to JSON7 %
- Ungroup7 %
- GET Request7 %
- Salesforce SOQL6 %
- JSON Path6 %
- Column Filter4 %
- XML to JSON4 %
- MongoDB Reader3 %
- POST Request3 %
- Container Input (JSON)3 %
- Table to JSON2 %
- JSON to Table2 %
Row Filter (deprecated)2 %- Columns to JSON1 %
CSV Reader< 1 %- Table Creator< 1 %
- Table Transposer< 1 %
- Loop End< 1 %
Line Reader< 1 %- String Manipulation< 1 %
Column Appender< 1 %- Column List Loop Start< 1 %
- JSON Transformer< 1 %
- JSON to XML< 1 %
- Java Snippet< 1 %
- Chunk Loop Start< 1 %
JSON Reader< 1 %- CSV Reader< 1 %
- Column Splitter< 1 %
- JSON Column Combiner< 1 %
- JSON Row Combiner< 1 %
- HTTP Result Data Extractor< 1 %
- Elasticsearch Reader (ES 6)< 1 %
- Variable to Table Column< 1 %
- Concatenate< 1 %
- End IF< 1 %
CASE Switch Data (Start)< 1 %- Joiner< 1 %
Table Row To Variable Loop Start< 1 %Column Rename< 1 %- Column Filter (legacy)< 1 %
- Duplicate Row Filter< 1 %
- Unpivot< 1 %
Python Script (1⇒1)< 1 %- PUT Request< 1 %
Table Row to Variable< 1 %Loop End< 1 %- Rule-based Row Filter< 1 %
- Table View (JavaScript)< 1 %
- Container Output (JSON)< 1 %
- Pivot< 1 %
- Kafka Consumer< 1 %
- Excel Reader< 1 %
- Wait...< 1 %
Recursive Loop End< 1 %- Partitioning< 1 %
- RowID< 1 %
- Rule-based Row Splitter< 1 %
- Inject Variables (Data)< 1 %
- Table Column to Variable< 1 %
- Variable Condition Loop End< 1 %
- MongoDB Run Command< 1 %
- Neo4j Writer< 1 %
- Split Collection Column< 1 %
Generic Loop Start< 1 %- HTTP Retriever< 1 %
- Container Input (Row)< 1 %
- Webpage Retriever< 1 %
- Constant Value Column Filter< 1 %
- Column Renamer< 1 %
- GroupBy< 1 %
Joiner< 1 %- Row Sampling< 1 %
- Empty Table Switch< 1 %
- Container Output (Table)< 1 %
- Python Source (legacy)< 1 %
- File Reader (Complex Format)< 1 %
- Recursive Loop End< 1 %
- Workflow Summary Extractor< 1 %
- Credentials Configuration< 1 %
- JSON Writer< 1 %
Call Local Workflow (Row Based)< 1 %- Recursive Loop Start< 1 %
- PATCH Request< 1 %
- Date&Time Part Extractor< 1 %
- Binary Objects to Strings< 1 %
- Breakpoint< 1 %
- Catch Errors (Data Ports)< 1 %
- Try (Data Ports)< 1 %
File Reader< 1 %- Group Loop Start< 1 %
Recursive Loop Start< 1 %String To Number< 1 %- Column Merger< 1 %
- Cross Joiner< 1 %
Row Splitter (deprecated)< 1 %- Missing Value< 1 %
- Sorter< 1 %
- String Replacer< 1 %
- Rule Engine< 1 %
- IF Switch< 1 %
- Parallel Chunk Start< 1 %
- Table Editor (JavaScript)< 1 %
- Container Input (Table)< 1 %
- JSON Schema Validator< 1 %
MongoDB Reader< 1 %- XPath< 1 %
- Delete Files (legacy)< 1 %
- Cell Splitter< 1 %
- Column Auto Type Cast< 1 %
- Column Resorter< 1 %
- Constant Value Column< 1 %
- Table Validator< 1 %
- DB Query Reader< 1 %
- Column Expressions< 1 %
- JSON Path (Dictionary)< 1 %
- JSON Diff< 1 %
- Neo4j Reader< 1 %
- Table Row to Variable< 1 %
- Variable to Table Row< 1 %
- File Reader< 1 %
- Line Reader< 1 %
- Table Reader< 1 %
- Table Row to Variable Loop Start< 1 %
- Column Combiner< 1 %
- Column Appender< 1 %
- Table Manipulator< 1 %
- String Manipulation (Multi Column)< 1 %
- Timer Info< 1 %
- Capture Workflow Start< 1 %
- DB Reader< 1 %
- Container Input (Variable)< 1 %
- MongoDB Aggregation< 1 %
- Python Script (legacy)< 1 %
- DELETE Request< 1 %
- Salesforce Simple Query< 1 %
- Call Workflow (Row Based)< 1 %
- Generic Web Service Client< 1 %
- Row Filter (Labs)< 1 %
- CASE Switch Start< 1 %
- Call Workflow Service< 1 %
List Files< 1 %Number To String< 1 %- Cache< 1 %
Line Reader< 1 %Cell Splitter< 1 %- Java Edit Variable< 1 %
- Row Splitter (Labs)< 1 %
Concatenate (Optional in)< 1 %- Column to XML< 1 %
- HTML Parser< 1 %
Table Column to Variable< 1 %Database Connection Table Reader< 1 %- String Manipulation (Variable)< 1 %
- Counter Generation< 1 %
- TimeDelay Loop Start< 1 %
Excel Reader (XLS)< 1 %- Java IF (Table)< 1 %
- String Input (legacy)< 1 %
Regex Extractor< 1 %Cell Replacer< 1 %Interval Loop Start< 1 %- Random Forest Predictor< 1 %
- Extract Table Dimension< 1 %
- Parallel Chunk End< 1 %
- One Row to Many< 1 %
Python Script (1⇒1)< 1 %Table Row to Variable< 1 %Variable to Table Row< 1 %Table Reader< 1 %Variable Condition Loop End< 1 %Variable Loop End< 1 %- Column Aggregator< 1 %
- Create Table Structure< 1 %
- TimeDelay Loop End< 1 %
- External Tool< 1 %
Excel Reader (XLS)< 1 %Container Input (Variable)< 1 %- String to XML< 1 %
- Expand Bit Vector< 1 %
- Number to String< 1 %
- Value Counter< 1 %
- List Files/Folders< 1 %
- File Chooser (legacy)< 1 %
- Credentials Widget< 1 %
- XML Reader< 1 %
- Download (legacy)< 1 %
Variable to Table Row< 1 %Database Reader< 1 %- Loop End (Column Append)< 1 %
Counting Loop Start< 1 %- Column Name Extractor< 1 %
- Column Rename (Regex)< 1 %
Merge Variables< 1 %- Start WebDriver< 1 %
- Load text-based files< 1 %
- Elasticsearch Console (ES 6)< 1 %
- String to Table< 1 %
- Create Collection Column< 1 %
- URL to File Path< 1 %
- Catch Errors (Generic Ports)< 1 %
Variable to Table Column< 1 %- Extract Variables (Data)< 1 %
Database Table Selector< 1 %Recursive Loop Start (2 ports)< 1 %- PCA< 1 %
- Column to Grid< 1 %
- Many to One< 1 %
- Filter Apply< 1 %
String Replace (Dictionary)< 1 %- Single sample t-test< 1 %
CASE Switch Data (End)< 1 %- Merge Variables< 1 %
- Color Manager< 1 %
- Spark to Table< 1 %
- DB Table Selector< 1 %
- PMML Ensemble to Table< 1 %
- Math Formula< 1 %
- String Configuration< 1 %
- Boolean Input (legacy)< 1 %
- Date&Time Input (legacy)< 1 %
- Integer Input (legacy)< 1 %
MongoDB Remove< 1 %- R Snippet< 1 %
- Legacy Date&Time to Date&Time< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Date&Time-based Row Filter< 1 %
- Window Loop Start< 1 %
- Extract Time Window (legacy)< 1 %
- Twitter Search< 1 %
Twitter Streaming< 1 %- Twitter Timeline< 1 %
- XML Column Combiner< 1 %
XML Reader< 1 %- Remove Empty Rows< 1 %
HTTP Retriever< 1 %- Find Elements< 1 %
- Chunk Loop Run-to-time Loop Start< 1 %
- Benchmark End< 1 %
- Benchmark Start< 1 %
- Catch Errors (Var Ports)< 1 %
- Try (Variable Ports)< 1 %
Variable to Table Column< 1 %- Generic Loop Start< 1 %
- Reference Row Filter< 1 %
- HDFS File Permission (legacy)< 1 %
- Tile View (JavaScript)< 1 %
- File Upload Widget< 1 %
- Integer Widget< 1 %
- String Widget< 1 %
- Container Input (Credentials)< 1 %
- Python Edit Variable (legacy)< 1 %
- String to Date&Time< 1 %
- Workflow Service Input< 1 %
- Table to HTML String< 1 %
- Web Page Content 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.