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
Solved! Go to 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 🙂