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.

ForEach formula expression in Alteryx

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.

Expression

Accepted answers

MarqueeCrew

@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

ForEach formula expression.yxmd

All comments

Thableaus

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:

1 = Messages
2 = Warnings
3 = Errors
5 = Conv Errors (field conversion errors)
8 = Files (input)
9 = Files (output)

Let us know if you have questions.

Cheers,

mceleavey

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.

workflow.yxmd

MarqueeCrew

@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

ForEach formula expression.yxmd

afv2688

Hello @GP2 ,

Hope this helps!

Cheers

alarm_workflow.yxmd

alarm.yxmc

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335