We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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
15 - Aurora
15 - Aurora

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
15 - Aurora
15 - Aurora

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