Icon

Forum - build a sequence of rows

Demonstrates building a sequence of rows from a given starting point in a table, using One Row to Many and Rank nodes

Sample Datawith plainnumericNote the originalrowidduplicate therowsset the new rowvalue basedon the sequencegeneratesequence within each group, from 1 onwardstidy upSample Datawth alphanumericNote the originalrowidduplicate therowsgeneratesequence within each group, from 1 onwardsseparate thecode lettersfrom code numbertidy upset the new rowvalue basedon the sequenceFix col namesCodeNumberas integerJoin code lettersand code numberback into Start NumberTable Creator RowID One Row to Many Math Formula Rank Column Filter Table Creator RowID One Row to Many Rank Regex Split Column Filter Math Formula Column Rename String To Number String Manipulation Sample Datawith plainnumericNote the originalrowidduplicate therowsset the new rowvalue basedon the sequencegeneratesequence within each group, from 1 onwardstidy upSample Datawth alphanumericNote the originalrowidduplicate therowsgeneratesequence within each group, from 1 onwardsseparate thecode lettersfrom code numbertidy upset the new rowvalue basedon the sequenceFix col namesCodeNumberas integerJoin code lettersand code numberback into Start NumberTable Creator RowID One Row to Many Math Formula Rank Column Filter Table Creator RowID One Row to Many Rank Regex Split Column Filter Math Formula Column Rename String To Number String Manipulation

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: BATEB031
Created at: 2023-06-30
On NodePit since: 2023-06-30
Last update: 2024-04-27
Created with KNIME version: v4.7.4
Tags: sequenceOne Row to ManyCreating RowsDuplicating RowsDuplicationRow Creation

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

Try NodePit Runner!