Hello
I have the following Module, I require the Fascia to be replaced with the "The Food Warehouse" when the fascia has the word "Warehouse" in it but has "Iceland" in the Company field.
Hi, all you need to do it is swap [Fascia] and "Warehouse" in your findstring function
if [Company] = "Iceland" then if contains([Fascia],"Warehouse") then "The Food Warehouse"else [Fascia] endifelse [Fascia] endif
Should do the trick.
Hey @Mancunian!
Try the following expression in your Formula tool:
iif([Company]='Iceland' && contains([Fascia],"Warehouse"),"The Food Warehouse",[Fascia])
Here we make use of the contains function.
Hope this helps!
IF [Company] = "Iceland" AND Contains([Fascia],"Warehouse")THEN Replace([Fascia],"Warehouse", 'The Food Warehouse')ELSE [Fascia]ENDIF
Based upon the text of you post, this is what I see a potential solution looking like.
Cheers,
Mark
HA! Three solutions in less than a minute! Hopefully one works!
Alteryx Community at its best!
3 answers within 5 minutes of the question being posted, all slightly different responses as well.
