Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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