Icon

Excel to JSON Multilayer nested arrays objects

Using a loop to create json from input xls file

Make original multiple columns into a "stacked" multi-row table of the 3 (renamed) columns Node 5di2di4di4combine dibase vs diModify ColumnNamesGroup by"columnName"Turn thru 90 degreesMake RowIDout of ColumnNameready for transposingto json1 row at a timerepeatstore origalrowIdto allow re-connectionlaterNode 34Keep rowIdput back originalrowIdto jsondi5Node 39 Excel Reader Columns to JSON Columns to JSON Columns to JSON JSON ColumnCombiner Column Appender Column Splitter Unpivoting Rule Engine GroupBy Transpose RowID Ungroup Table to JSON Column Appender Columns to JSON Chunk Loop Start Loop End RowID Column Appender Column Filter RowID Columns to JSON Columns to JSON Column Filter Make original multiple columns into a "stacked" multi-row table of the 3 (renamed) columns Node 5di2di4di4combine dibase vs diModify ColumnNamesGroup by"columnName"Turn thru 90 degreesMake RowIDout of ColumnNameready for transposingto json1 row at a timerepeatstore origalrowIdto allow re-connectionlaterNode 34Keep rowIdput back originalrowIdto jsondi5Node 39 Excel Reader Columns to JSON Columns to JSON Columns to JSON JSON ColumnCombiner Column Appender Column Splitter Unpivoting Rule Engine GroupBy Transpose RowID Ungroup Table to JSON Column Appender Columns to JSON Chunk Loop Start Loop End RowID Column Appender Column Filter RowID Columns to JSON Columns to JSON Column Filter

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: arjen
Created at: 2023-06-14
On NodePit since: 2023-06-23
Last update: 2024-04-28
Created with KNIME version: v4.7.4

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!