Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Flag Rows

df
8 - Asteroid

Hello community,

 

I have numbers in one column (Nr). Now i want to "flag" x rows after where x is the number in this column.

The important thing is: If the numbers overlap the "flags" should be added.

Example

31first flag of 3
22second flag of 3 + first flag from 2
13last flag from 3 + last flag from 2 + first flag from 1

 

attached a workflow with testdata

 

grafik.png

2 REPLIES 2
CharlieS
17 - Castor
17 - Castor

Hey, @df.

 

I found the Generate Rows tool to be very helpful in this situation. My solution is attached.

BenMoss
ACE Emeritus
ACE Emeritus

This one took me a while to crack but I got there.

 

Solution attached.

 

Ben

Labels