Icon

KNIME_​project21

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 }]combineExcel 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 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 }]combineExcel 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

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.2

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

Try NodePit Runner!