FindString then replace

acerdell

Hello Alteryx friends,

I have been trying to use findstring fuction in formula tool in alteryx based on multifields but could not get it sorted out. 

IF product code is 9 (regardless of other fields)--status is 9:FAIL

if product brand is empty while product sub category is NOT Empty regardless of the product code--status is 9:FAIL 

Else everything else is PASS

Product Brand	Product Sub Cat	Product Code	Status
Sanane	RX1	1	1:Pass
Trrims	tt1	9	9:Fail
	SEQ	6	6:Fail
karsta	or3	5	6:Pass
	saf11	9	9:Fail

Joe_Mako

Are you looking for something like this:

IF [Product Code]=9 THEN "9:FAIL"
ELSEIF IsEmpty(Product Brand) AND !IsEmpty([Product Sub Cat]) THEN "9:FAIL"
ELSE ToString([Product Code])+":PASS" ENDIF