Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
ALTER.NEXT:

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
SOLVED

Pulling value from one field if another field is Null

Highlighted
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

Alteryx Certified Partner
Alteryx Certified Partner

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

Highlighted
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?  

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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

Highlighted
7 - Meteor

Thanks again!

Labels