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 · Accepted solution]

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

[fomenter]

Yes I was looking for something similar.I made it more complicated than it needs to be, at least this will work for me

[acerdell]

I guess it works for me too with a little change in my format. Thank you for your help