The Inspire Pin contest has begun! Win a free pass to Inspire by submitting your design to be made into a real-life pin! Submission details can be found here.

Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Creating a variable with paramters

Riot
8 - Asteroid

Im trying to create a 1,0 variable that states if the subject is a mother. 

 

So i am looking for something like  

 

If Age 0<

and

Gender = F 

and 

Kids 0< 

Then Mother =1

Else 0 

 

But I can't quite get it. 

 

2 REPLIES 2
jdunkerley79
ACE Emeritus
ACE Emeritus

Try:

 

IF [Age] > 0 AND [Gender] = 'F' AND [Kids] > 0
THEN 1
ELSE 0
ENDIF 
 

In a formula tool:

ismother.jpg

Riot
8 - Asteroid

 

Perfect!!

Labels