We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Multi Row Formula from specific value until a different specific value

DanielCarro
8 - Asteroid

Hi Guys,

 

I am struggling with this Multi Row Formula which I have the following:

TEST
false

false

true
false
false
close
false
false
true
false
close
false

 

 

What i need is the following output

TESTResult
false

false

false

false

truetrue
falsetrue
falsetrue
closefalse
falsefalse
falsefalse
truetrue
falsetrue
closefalse
falsefalse
falsefalse

 

I would appreciate any advise.

Kind Regards,

Dan

2 REPLIES 2
griffinwelsh
12 - Quasar

@DanielCarro if I understand the requirement properly you can use the below formula. Example is attached as well. Please mark the thread solved if this fit your needs.

 

if [TEST] = "close" then "false"
elseif [Row-1:Result] = "true" then "true"
else [TEST] endif

DanielCarro
8 - Asteroid

Hi @griffinwelsh , it worked perfectly

Labels
Top Solution Authors