Hi Community,
Need some help please, I'm trying to write a IF Contains, and or IF in the same statement. But getting a Malformed IF Statement
My Formula us
if Contains([Locator], 'KARDEX') THEN 'KARDEX' OR if Contains([Locator], 'KLX') THEN 'Warehouse'
OR
IF [Locator]='BRD1..' THEN 'BIBAK' ELSEIF [Locator]='KLX-NYK..' THEN 'YUSEN' ELSE 'NUll' ENDIF
Picture of Error / formula, and the excel of the locators.
Any help is appreciated. TIA Karl
Solved! Go to Solution.
Hi @Karl_Spratt try this If Contains([Locator], 'KARDEX') THEN 'KARDEX' ELSEIF Contains([Locator], 'KLX') THEN 'Warehouse'
ELSEIF [Locator]='BRD1..' THEN 'BIBAK' ELSEIF [Locator]='KLX-NYK..' THEN 'YUSEN' ELSE Null() ENDIF
Hi @Karl_Spratt
Here is an interactive lesson which will give you more understanding in tackling this kind of scenario.
https://community.alteryx.com/t5/Interactive-Lessons/Writing-Conditional-Statements/ta-p/98910#done
Hope this helps 🙂