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

Pulling value from one field if another field is Null

tj3678
7 - Meteor

Hi everyone,

 

Back again in need of some help.  See data sample below - I am trying to pull the value from VALUE_RETURN field when the CREDITVALUE_PMT field is blank/null and place in a new column.  much appreciated!

 

Capture.PNG

5 REPLIES 5
JosephSerpis
17 - Castor
17 - Castor

hi @tj3678 this might solve your problem please let me know if it doesn'tIf_Statement.JPG?

tj3678
7 - Meteor

Thanks @JS420 ! This worked! 

 

May I ask one more scenario - what if I wanted to replace the null value in CREDITVALUE_PMT with the value in VALUE_RETURN?  

JosephSerpis
17 - Castor
17 - Castor

HI @tj3678 

                   I kept the previous formula but also as requested created a new formula which will replace null value CREDITVALUE_PMT with the value in VALUE_RETURN. I also attached the workflow as well. If this solution been helpful could I ask you mark this as being solved please? If_Statement.JPG

tj3678
7 - Meteor

Thanks again!

Madhu-Navuluri
6 - Meteoroid

@JosephSerpis

 

you are answer solved my issueue

 

Thanks,

Madhu

Labels