IF THEN ELSE Formula with startswith - not returning value

aurorab

Hello,

I'm fairly new to Alteryx. I'm preparing a workflow and am near the end.

I am attempting to create an IF THEN ELSE function that essentially says "If the Purchase Order column starts with ___, then change the Customer Name column to ___, or else keep as ____". There are four criteria that I need for this function, and I have all four separated into their own functions, and they are identical except for the "starts with" criteria. There are no errors within the functions, and when I run the workflow, only one criteria changes the customer name to what it needs to be.

Two of the functions have "starts with" data that are letters and numbers, one is just numbers, and the function that worked is just letters.

Is the reason for the only letters function working because it only contained letters? If so, what is the best way to also return the remaining three functions?

IF THEN ELSE.pdf

vizAlter

Hi @aurorab — Welcome to the Alteryx Discussions!

Try this solution... you can solve this in two ways;

1) Use your StartsWith expression like below:

IF StartsWith([PURCHASE_ORDER], "A1")
	OR  StartsWith([PURCHASE_ORDER], "A2")
	OR  StartsWith([PURCHASE_ORDER], "1234")
	OR	 StartsWith([PURCHASE_ORDER], "AAAA") THEN 
	"New" 
ELSE 
	"Original" 
ENDIF

2)  Use a RegEx expression:

IF REGEX_Match([PURCHASE_ORDER], "^(A1|A2|1234|AAAA).*$") THEN 
	"New" 
ELSE 
	"Original" 
ENDIF

If this assists please mark the answer "Solved", if not let me know!

If Else with RegEx or StartsWith__vA.yxmd