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