Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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