Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
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?  

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