Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Filter Tool

ashiques
8 - Asteroid
 
Hi
When i used this Formula
IF left([Name], 7) == "A_Fract" THEN left([Name], 7) == "A_Fract" ELSE left([Name], 11) == "B_Analytics" ENDIF

I have to make check on two Words.I want only one value from Field but i got both the values of "A_Fract" and "B_Analytics". How can i get only one value.
Like  first i find "A_Fract" then if its not found then find "B_Analytics". I didnt get one value.

 
1 REPLY 1
ChadM
Alteryx Alumni (Retired)
Hi Ashique,

Try the following:

IF left([Name], 7) == "A_Fract"
THEN "A_Fract"
ELSEIF left([Name], 11) == "B_Analytics"
THEN "A_Fract"
ELSE "No Value"
ENDIF


With the If/Then statement, you are looking for two values, if the first isn't found, make the second value part of your ELSEIF statement.  Finally, if neither of the two values are found, use the ELSE to signify the alternative.

Thanks! 
Labels