Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Simple Conditional Formula

mattcoleman
8 - Asteroid

This seems like it should be easy to do, but I can't figure it out. I'm trying to identify runs by looking at a field called 'STEP'.

 

I used a Multi-Row tool for 'STEP-1' which looks at the previous step value. When 'STEP-1' = 0 and 'STEP' > 0, it's a new run and I want a new column to start with '1' as the run. The next time the test passes (goes from 0 to a non-zero number), I want run '2' listed, which would be the current value + 1.

 

When I try and reference the Output Column (Step_Test) in the formula tool, it gives me an Unknown Variable error.

 

mattcoleman_0-1633382223284.png

 

12 REPLIES 12
atcodedog05
22 - Nova
22 - Nova

Hi @mattcoleman 

 

Sorry, my bad updated it.

 

Workflow:

atcodedog05_0-1633451574724.png

 

Hope this helps : )

mattcoleman
8 - Asteroid

Many thanks, that worked!!!!

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @mattcoleman 

Cheers and have a nice day!

Labels
Top Solution Authors