This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi, I'm struggling to tag each row of the data with a Category define by End User.
Data contains store detail from Col A:G. I would like to return Category (A/B/Null) along each data under Col H.
Category rule is specified in a separate worksheet
User will define String condition under Col A for Field "City". E.g. If City contains "Springs", return Category A. Anything outside this rule will return Null category.
Understand we can build the static logic in the designer, however our End-user doesn't have designer and will maintain the logic over a spread sheet instead.
Attached spread sheet containing Database and logic.
Much appreciate if anyone can help here! Happy New Year to all and wish you all success 2019.
This sounds like a great use case for the Dynamic Replace Tool.
There are a couple great examples in the designer that should hopefully help you with what you need.
If you do get stuck, reach back out on here and I can build an example for you.
Hmmm, I thought a simple formula tool like this would work - but I keep getting everything coming up NULL:
IF Contains("SPRINGS", [City]) then "A"ELSEIF StartsWith("LO", [City]) THEN "B"ELSE Null()ENDIF
Not sure why this isn't working
@michael_heitz - it needs to be read through from a separate workbook/file and not a formula within Alteryx itself, as the end user won't have Alteryx Designer.
Also, I think you have your string and fields the wrong way round, it should be:
IF Contains([City], "SPRINGS") then "A"
ELSEIF StartsWith([City], "LO") THEN "B"
I guess you need the case insensitive parameter to return the right Bool. thanks anyway
Both Contains and StartWith are case insensitive by default, so we are OK on that front, but well worth keeping that in mind when using string functions like this.