Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

IF/THEN

nihou
8 - Asteroid

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
3 REPLIES 3
nihou
8 - Asteroid

 

 

Ar13f
10 - Fireball

Dear @nihou 

 

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

 

Nihou solution.png

Qiu
20 - Arcturus
20 - Arcturus

A master table should be easier for maitenance.

Capturew1.PNG

Labels