Icon

Transform Vanguard Report

Calculate how often each row with the group information needs to be replicated Create and add a row with with the number of rows in the original table +1 Create Example DataCreate a new columnwith a countReplicate the group infoOnly "header rows",aka rows with value Row 1Append columnwith rep infoCalculate the rep numberRemove superflouescolumnsRemove "header"rows, aka rowswith Row 1 Table Creator Counter Generation One Row to Many Row Filter Column Appender Column Appender Lag Column Math Formula Extract TableDimension Row Filter Concatenate Math Formula Column Filter Row Filter Calculate how often each row with the group information needs to be replicated Create and add a row with with the number of rows in the original table +1 Create Example DataCreate a new columnwith a countReplicate the group infoOnly "header rows",aka rows with value Row 1Append columnwith rep infoCalculate the rep numberRemove superflouescolumnsRemove "header"rows, aka rowswith Row 1 Table Creator Counter Generation One Row to Many Row Filter Column Appender Column Appender Lag Column Math Formula Extract TableDimension Row Filter Concatenate Math Formula Column Filter Row 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: kathrinmelcher
Created at: 2021-12-02
On NodePit since: 2021-12-06
Last update: 2024-05-02
Created with KNIME version: v4.4.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!