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

Increment by 1 based on another row

bleu
8 - Asteroid

I need help trying to fill down these rows based on another row that's filled with only 1s and Nulls:

 

 

Site          Desired Output
[Null] 
1              1
[Null]         1
1              2
[Null]         2
[Null]         2
1              3
[Null]         3
[Null]         3
1              4
[Null]         4
[Null]         4
[Null]         4
[Null]         4
1              5
[Null]         5
[Null]         5
1              6
[Null]         6

 

 

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@bleu 
We can use a Multi-Row formula tool for this purpose as below.
The first one will be zero so we can will replace it with a Formula tool.

0710-bleu.PNG

binuacs
21 - Polaris

@bleu One way of doing this with the multi-row formula tool

binuacs_0-1657437078717.png

 

bleu
8 - Asteroid

Thank you Qiu, Thank you binuacs!

They both worked.

Really appreciate it! 😁

Labels
Top Solution Authors