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.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

IF/THEN

nihou
8 - Asteroid
‎10-11-2021 06:20 PM

I have tried the formula: 

 

IF Contains([SysProdCode]"GAS") and Contains([Type]"Processing" THEN '03'
ELSE IF Contains([SysProdCode]"GAS" and [Type]"Treatment" THEN '04'

 

Source

SysProdCodeType
GasProcessing
GasProcessing
GasTreatment

 

Desire Output

SysProdCodeTypePC
GasProcessing03
GasProcessing03
GasTreatment04
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

3 REPLIES 3
nihou
8 - Asteroid
‎10-11-2021 06:32 PM

 

 

Reply
0 Likes
Ar13f
10 - Fireball
‎10-11-2021 07:00 PM

Dear @nihou 

 

please see the workflow below ... I hope this is what you are looking for

 

Nihou solution.png

Reply
Qiu
21 - Polaris
21 - Polaris
‎10-11-2021 07:31 PM

A master table should be easier for maitenance.

Capturew1.PNG

New Workflow1-W1.yxmd
Reply
GenAI Contest Form
Data Connection Manager
Labels
Top Solution Authors
View All