In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

General Discussions

Discuss any topics that are not product-specific here.

Capturing unnecessary items

Cherkos12
7 - Meteor

Hi -

My formula is capturing an item that i don't need in the output. I tried using the if contains formula to capture only the ones highlighted in brown but 'unqualified' is also being captured. How'd i go about creating a formula to ONLY capture 'qualified' 'SAL' and 'SQL'

 

Thanks

 

Lead_IDLead_Status
00Q3m000015AZ1HEAWMQL
00Q3m000015AchvEACQualified
00Q3m000015AQXnEAOSAL
00Q3m000015ANrLEAWSQL
00Q3m000015AHSVEA4Unqualified
1 REPLY 1
mathieuf
Alteryx
Alteryx

Hi @Cherkos12,

 

Is it what you are looking for:

 

mathieuf_0-1639135495098.png

 

Please see attached workflow

Labels
Top Solution Authors