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
9 - Comet

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
9 - Comet

@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