Alteryx Designer Desktop Discussions

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

Changing Part of a Formula Tool through an App

keng
8 - Asteroid

Hi, 

 

I'm trying to replace part of a formula through a text input in an Alteryx app. 

 

For some reason, it is not working. I want the users to have the flexibility of using the OR function as well if they have multiple choices. Any suggestions on why this might not be working? 

Text Box.PNG
Action.PNG
Formula.PNG
Overview.PNG

    

2 REPLIES 2
apathetichell
19 - Altair

Your formula is wrong. OR 'Tuscon' is a boolean - like OR ('Tuscon'=True).  Even it still replaces it you are replacing it with a new Boolean expression which will be false.

 

you want an IN statement here  value IN('Tuscon','Phoenix') you should then replace what's in your IN statement (except the parenthesis EXACTLY. So your user will have to enter something like "Tuscon","Phoenix" - I would recommend using a listbox for this with lisbox -> list mode -> actoin tool - repalce vs the way you are doing this. 

keng
8 - Asteroid

You are a lifesaver! Thank you! 

Labels