I would need to add two new columns to my dataset:
Column 1: Have the same value for three rows then add +1, e.g:
Column 2: Add numbers from 1 to 3 constantly to rows, e.g.
Below is a picture of what i’m trying to achieve. I guess column expressions could do the job, but I haven’t figured this it out and any help would be much appreciated!
See this KNIME_project.knwf (25.9 KB)
Thank you for fast reply that solved my problem!
Not a loop fan so here is a bit of math do deal with above request.
Check it out here:
Welcome to KNIME Community @Ilkka!
Thanks @ipazin for sharing, very interesting way to avoid looping!
It’s amazing what kind of cool solutions you guys come up with.
Depending on your dataset size you can use a crossjoiner (sorry only works for your second column )
here is a bit generalized workflow to get repeated sequences and/or Grouping column using Math Formula node:
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.