Do we have Break in alteryx

[ferha_jafri]

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

[atcodedog05 · Accepted solution]

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:

Hope this helps 🙂