This node transforms a JSON column into multiple columns by automatically inferring the structure of the
JSON data. It works best with well-structured, relatively flat JSON objects that follow a consistent schema
across all rows.
You can choose between two main extraction approaches. One option is to extract only the primitive leaf
values (such as strings or numbers), ignoring their full JSON paths. The other option is to retain the
complete JSON structure. However, keeping the full structure may lead to less intuitive results, since the
resulting columns can contain JSON values or collections of JSON rather than simple data types.
For example, consider JSON inputs like:
{"a": {"b": [1, 2], "c": "c"}}{"a": {"b": [3], "d": null}}
- b: either a JSON array or a list of integers, depending on whether arrays are preserved as JSON or expanded into collections
- c: string values
- d: string values (with missing entries where not present)
Another option is to use full JSON paths as column names (for example,
a.b.0, a.b.1,
a.c, a.d) and expand arrays into separate columns. This produces more granular columns,
such as individual elements of arrays and nested fields.For more complex nested structures, behavior depends on additional settings:
- If nested objects are omitted and only shallow levels are considered, arrays may be simplified to lists of primitive values.
- If nested objects are kept, arrays can contain mixed JSON elements (e.g., objects and numbers together).
- When preserving arrays as JSON, the output remains closer to the original structure regardless of other settings.
Options
Popular Predecessors
- Ungroup5 %
- GET Request4 %
- JSON Reader3 %
- JSON Path3 %
- String to JSON2 %
- Salesforce SOQL2 %
CSV Reader2 %Row Filter (deprecated)2 %Line Reader1 %- XML to JSON1 %
Column Appender1 %- Java Snippet1 %
- Column Filter1 %
- HTTP Result Data Extractor< 1 %
- Variable to Table Column< 1 %
- End IF< 1 %
CASE Switch Data (Start)< 1 %Table Row To Variable Loop Start< 1 %- Column Filter (legacy)< 1 %
Python Script (1⇒1)< 1 %- MongoDB Aggregation< 1 %
- PUT Request< 1 %
Table Row to Variable< 1 %Loop End< 1 %- Table View (JavaScript) (legacy)< 1 %
- Container Output (JSON)< 1 %
- POST Request< 1 %
- Pivot< 1 %
- Joiner< 1 %
Recursive Loop End< 1 %- Table Partitioner< 1 %
- Rule-based Row Splitter< 1 %
- JSON to Table< 1 %
- Unpivot< 1 %
- Inject Variables (Data)< 1 %
- Table Column to Variable< 1 %
- MongoDB Reader< 1 %
- MongoDB Run Command< 1 %
- Neo4j Writer< 1 %
Generic Loop Start< 1 %- RowID< 1 %
- Rule-based Row Filter< 1 %
- Container Input (JSON)< 1 %
- HTTP Retriever< 1 %
- Container Input (Row)< 1 %
- Constant Value Column Filter< 1 %
- Column Renamer< 1 %
Joiner< 1 %Column Rename< 1 %- Row Sampler< 1 %
- String Manipulation< 1 %
- Table Transposer< 1 %
- Table to JSON< 1 %
- JSON Transformer< 1 %
- DB Query Reader< 1 %
- Container Output (Table)< 1 %
- Python Source (legacy)< 1 %
- CSV Reader< 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 %
- Split Collection Column< 1 %
- Binary Objects to Strings< 1 %
- Breakpoint< 1 %
- Wait...< 1 %
- Catch Errors (Data Ports)< 1 %
- Try (Data Ports)< 1 %
File Reader< 1 %Table Creator< 1 %- Chunk Loop Start< 1 %
- Column List Loop Start< 1 %
- Group Loop Start< 1 %
Recursive Loop Start< 1 %- Concatenate< 1 %
String To Number< 1 %- Column Merger< 1 %
- Cross Joiner< 1 %
Row Splitter (deprecated)< 1 %- GroupBy< 1 %
- Missing Value< 1 %
- Sorter< 1 %
Column Splitter< 1 %- String Replacer< 1 %
- Rule Engine< 1 %
- Empty Table Switch< 1 %
- IF Switch< 1 %
- Parallel Chunk Start< 1 %
- Table Editor (JavaScript) (legacy)< 1 %
- JSON Column Combiner< 1 %
- JSON Row Combiner< 1 %
- Container Input (Table)< 1 %
JSON Reader< 1 %- JSON Schema Validator< 1 %
- Columns to JSON< 1 %
- JSON to XML< 1 %
MongoDB Reader< 1 %- XPath< 1 %
Delete Files< 1 %- Cell Splitter< 1 %
- Column Auto Type Cast< 1 %
- Column Resorter< 1 %
Constant Value Column< 1 %- Table Validator< 1 %
- Duplicate Row Filter< 1 %
- Column Expressions (legacy)< 1 %
- JSON Path (Dictionary)< 1 %
- JSON Diff< 1 %
- Kafka Consumer< 1 %
- Webpage Retriever< 1 %
- Neo4j Reader< 1 %
- Table Row to Variable< 1 %
- Variable to Table Row< 1 %
- File Reader (Complex Format)< 1 %
- Line Reader< 1 %
- Table Reader< 1 %
- Loop End< 1 %
- Variable Condition Loop End< 1 %
- Recursive Loop End< 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 %
- Excel Reader< 1 %
- Container Input (Variable)< 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 %
- Table Structure Creator< 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< 1 %Variable to Table Row< 1 %Database Reader< 1 %- Loop End (Column Append)< 1 %
Counting Loop Start< 1 %- Column Name Extractor< 1 %
- Column Name Replacer< 1 %
Merge Variables< 1 %- Start WebDriver< 1 %
- Load text-based files< 1 %
- String to Table< 1 %
- Columns to Collection< 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< 1 %- Twitter Search (legacy)< 1 %
Twitter Streaming (legacy)< 1 %- Twitter Timeline (legacy)< 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< 1 %Tile View (JavaScript) (deprecated)< 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 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
- _Predictor_FlowKNIME Hub
- 00_bindingsiteexplorationKNIME Hub
- 0034从JSON中提取坐标KNIME Hub
- Show all 839 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.