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
20 - Arcturus
20 - Arcturus

@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
20 - Arcturus

@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