Alteryx designer Discussions

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

Highlighted
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