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 It contains or blank

mmustkee
10 - Fireball

HI Team,

 

I have a table below and I want if my column, "Owner" is null and 'Station' Column contains 'std' so std should be replaced with null values in column "Owner"

 

stationOwner
std 
isd 
pco 
stddfd
999 
axxcs999
STD 
std 

 

Thanks for your help in advance.

 

Thanks,

Mohammad Mustkeem

2 REPLIES 2
clmc9601
13 - Pulsar
13 - Pulsar

Hi @mmustkee,

 

Like this? Hope this workflow helps!

Screen Shot 2021-02-10 at 8.47.20 PM.png

 

mmustkee
10 - Fireball

@clmc9601

 

I checked and found that my required column got interchanged in your workflow. The value of column 'station' to be replaced in column 'Owner' if condition matched. However I have now understood the logic and  applied as per my request.

 

Thanks for your help.

 

Thanks,

Mohammad Mustkeem

Labels
Top Solution Authors