Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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
Top Solution Authors