Icon

KNIME_​project21_​test.knwf 2

Node 915loop throughKPIs one at a timeget columnsas rows forprocessingget KPIs which should appear in the submetricsfilterunneeded metricsconvert numbersto stringscreate KPIjson layoutfilter for jeson KPI group headerNode 924get group header layoutconcat to JSONgroupcombine elementsadd opening {add closing }Node 932get RowID info as new coland replace with generic rowidadd opening"submetrics": [add closing }]combineNode 939get KPIs which should appear in the submetricsNode 924get RowID info as new coland replace with generic rowidcreate KPIjson layoutcombine elementscombinefilter for jeson KPI group headerNode 947get group header layoutadd closing }]add opening {concat to JSONgroupadd closing }get columnsas rows forprocessingfilterunneeded metricsNode 957add opening"submetrics": [Node 960Node 961loop throughKPIs one at a timeNode 963get KPIs which should appear in the submetricsExcel Reader (XLS) Chunk Loop Start Transpose Table Creator Joiner Number To String String Manipulation Row Filter RowID String Manipulation GroupBy GroupBy Table Creator Concatenate Table Creator Loop End RowID Table Creator Table Creator GroupBy Concatenate Loop End Table Creator RowID RowID String Manipulation GroupBy GroupBy Row Filter Loop End String Manipulation Table Creator Concatenate Table Creator Concatenate GroupBy Table Creator Transpose Joiner Loop End Table Creator Column Filter Column Filter Chunk Loop Start Reference RowSplitter Table Creator Node 915loop throughKPIs one at a timeget columnsas rows forprocessingget KPIs which should appear in the submetricsfilterunneeded metricsconvert numbersto stringscreate KPIjson layoutfilter for jeson KPI group headerNode 924get group header layoutconcat to JSONgroupcombine elementsadd opening {add closing }Node 932get RowID info as new coland replace with generic rowidadd opening"submetrics": [add closing }]combineNode 939get KPIs which should appear in the submetricsNode 924get RowID info as new coland replace with generic rowidcreate KPIjson layoutcombine elementscombinefilter for jeson KPI group headerNode 947get group header layoutadd closing }]add opening {concat to JSONgroupadd closing }get columnsas rows forprocessingfilterunneeded metricsNode 957add opening"submetrics": [Node 960Node 961loop throughKPIs one at a timeNode 963get KPIs which should appear in the submetricsExcel Reader (XLS) Chunk Loop Start Transpose Table Creator Joiner Number To String String Manipulation Row Filter RowID String Manipulation GroupBy GroupBy Table Creator Concatenate Table Creator Loop End RowID Table Creator Table Creator GroupBy Concatenate Loop End Table Creator RowID RowID String Manipulation GroupBy GroupBy Row Filter Loop End String Manipulation Table Creator Concatenate Table Creator Concatenate GroupBy Table Creator Transpose Joiner Loop End Table Creator Column Filter Column Filter Chunk Loop Start Reference RowSplitter Table Creator

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: JD
Created at: 2020-06-18
On NodePit since: 2022-02-06
Last update: 2024-04-27
Created with KNIME version: v4.1.3

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

Try NodePit Runner!