In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
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

binu_acs
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