Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
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