Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

If Contains - with multiple factors without having to use OR with each one

kas
8 - Asteroid

Hello,

 

I could write this using OR for each criteria, but there's quite a few and hoping there is an easier way.

 

Tried:  if CONTAINS([URL] IN ("ANB", "TAX","Support","SSP","SOC","PS","Annuities","MMSDRM","IFL","Fraud","AQA","FANB","FAS","DQ","DMS","DIClaims","Claims","ANB") then 'TRUE' ELSE 'FALSE' ENDIF

 

Rather than having to do:

if Contains([URL], 'ANB") or contains ([URL]. 'tax') or contains...etc for each value.

 

is this possible?

 

Thank you,

Kim

3 REPLIES 3
nagakavyasri
12 - Quasar

@kas This is possibly one solution:

Screenshot 2024-10-25 155441.png

kas
8 - Asteroid

@nagakavyasri 

 

That's a good thought...will take a close look at your option.

Will let you know :)

 

Thank you,

Kim,

kas
8 - Asteroid

@nagakavyasri 

 

This worked perfectly, thank you 🙂

Labels
Top Solution Authors