Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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