Multi Row Formula Tool

[ZoeM]

Community!

Thanks for all the great ideas I find here. You guys are really awesome.

In a previous thread, I got some ideas of modifying the expression in a multi row formula tool:

IF !isnull([End date])
then 'Achieved'
elseif [Row-1:Milestones]='Achieved'
then 'Next'
else 'Future'
endif

I need add additional states to the expression.  If the first phase of testing is in the future, it should not be called Future but Next, then when the last phase of testing is complete (has an end date) it should be moved to a new category called Post Completion.

Please reference the attached simple sample. 

Thanks!

Thread from previous conversation. 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/identifying-the-next-gateway-in-line-b...

[fmvizcaino · Accepted solution]

Hi @ZoeM ,

Happy to help you once again! 🙂

Attached is the adapted multi-row formula tool.

Let me know if that works for you.

Best,

Fernando Vizcaino

[ZoeM]

Just amazing!

Im learning more of this tool and I have a feeling it will be my new best friend...

Thanks Fernando!

[fmvizcaino]

Glad to hear that @ZoeM !!!

Multi-row formula is indeed an amazing tool, the only tool on top of that is the Regex Tool for me!

[ZoeM]

Hey Fernando,

What if its a brand new model and none of the stages have been met yet?

In the attached, I would like for BMW to show 'Next', its being filtered out into the Future category across all stages. 

[fmvizcaino]

Hi @ZoeM ,

I'm checking here and the first occurrence of 'BMW' is 'Next'.

Does it need to show next for all stages?

[ZoeM]

Very interesting.

I didnt catch that when I ran my actual data set.

It may be an issue on my end. 

Thanks Fernando!

[ZoeM]

Fernando!

Can I poke your brain a bit? 

What if I want to only highlight certain items and not others?

So in the case above, what if I want to skip Tires altogether and only consider Wheels, Roof, and Engine? 

I do not want to filter out Tires, but I want only the three mentioned to have the applicable field 'Stage'?