Is there a way to create an expression in Alteryx where it looks up conditions for each variable in a certain field.
Room ID | Category |
A | Cat 1 |
A | Cat 3 |
A | Cat 4 |
B | Cat 1 |
B | Cat 2 |
So for example for the above table I want an alert to be raised if a specific room ID contains both Cat 1 and Cat 3.
Solved! Go to Solution.
Hi @GP2
You can use either the Message Tool or the Formula tool with Message function.
See example:
You can see Designer actually left warnings when it found the records that you mentioned.
IF [Category] in ('Cat 1', 'Cat 3') THEN
Message(2, "Alert", "False")
ELSE "True" ENDIF
This goes to the log of your workflow.
The Message Function can be referenced here: https://help.alteryx.com/2018.2/Reference/Functions.htm
These are the message types:
Let us know if you have questions.
Cheers,
HI @GP2 ,
I've built a quick workflow which groups the categories by Room ID, and so you can see if Room A has both Categories:
Depending on how you want to be alerted you can use the Messaging tool. I've used an email tool to send you an email if it happens.
Hope this helps.
M.
@GP2 ,
I'd solve by searching the results of a Summarize (via concatenation) with this formula:
Contains([Concat_Category], "Cat 1") AND
Contains([Concat_Category], "Cat 3")
Cheers,
Mark