Icon

Duplicate Sample Without Looping

Duplicating and timeshifting rows

Workflow to demonstrate use of "One Row to Many" and "Rank" to enable duplication and modification of rows, for generating additional sample data

Additional column containing the number oftimes to duplicate each row is required for the"One Row to Many" node to operate We now just have a bunch of duplicate rows sowe need to differentiate each of them withintheir "grouping". The groupings are theSampleTime, so we can use Rank which willnumber each as 1..60 within SampleTime. Butwe really want to have this as 0..59 so we canuse it in shifting the time. So we need tosubtract 1 from the rank Calculate the new timewith time shift using the0..59 ranking Tidy up Sample DataAdd temp column"row_duplicator" with value 60Duplicate each row according to value of"row_duplicator"Remove the "calculation columns":"row_duplicator"and "rank" Shift the time by the rankingRank each of the rows within sample timeStart ranking at "zero" as we want it to be used as an offsetfor shifting the time Table Creator ConstantValue Column One Row to Many Column Filter Date&Time Shift Rank Math Formula Additional column containing the number oftimes to duplicate each row is required for the"One Row to Many" node to operate We now just have a bunch of duplicate rows sowe need to differentiate each of them withintheir "grouping". The groupings are theSampleTime, so we can use Rank which willnumber each as 1..60 within SampleTime. Butwe really want to have this as 0..59 so we canuse it in shifting the time. So we need tosubtract 1 from the rank Calculate the new timewith time shift using the0..59 ranking Tidy up Sample DataAdd temp column"row_duplicator" with value 60Duplicate each row according to value of"row_duplicator"Remove the "calculation columns":"row_duplicator"and "rank" Shift the time by the rankingRank each of the rows within sample timeStart ranking at "zero" as we want it to be used as an offsetfor shifting the time Table Creator ConstantValue Column One Row to Many Column Filter Date&Time Shift Rank Math Formula

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: p912366
Created at: 2021-01-05
On NodePit since: 2022-02-06
Last update: 2024-12-23
Created with KNIME version: v4.3.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!