Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Do we have Break in alteryx

ferha_jafri
8 - Asteroid

Hello Experts,

 

i want to know that do we have Break in alteryx, as I have a scenario in which if I find 1 in Flag  the it should not check the next row.

Eg.

Flag

0

0

1

0

2

3

So here I want to derive a Final column as if I find 1 it will not check the next  row.

Result

Final

0

0

1

0

0

1 REPLY 1
atcodedog05
22 - Nova
22 - Nova

Hi @ferha_jafri 

 

You can do this with use of multi-row formula tool. To check if previous row is 1 and retain the value.

 

Workflow:

atcodedog05_0-1622561469820.png

 

Hope this helps 🙂

 

Labels