Alteryx Promote Discussions

Find answers, ask questions, and share expertise about Alteryx Promote.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

Why Doesnt this work?

Highlighted
5 - Atom

IF [Length of Service1] <= 90 THEN '0-3 Months' elseif [Length of Service1] > 90 and [Length of Service1] <=180 THEN '3-6 Months' ELSEif [Length of Service1]> 180 and [Length of Service1] <= 365 then '6-12 Months' elseif [Length of Service1] >365 and [Length of Service1] <= 1095 then '1-3 Years' else if [Length of Service1] >1095 and [Length of Service1] <= 2190 then '3-5 Years' elseif [Length of Service1] >2190 and [Length of Service1] <= 3650 then '5-10 Years' elseif [Length of Service1] > 3650 and [Length of Service1] <= 5475 then '10-15 Years' else '15+ Years' ENDIF

Highlighted
14 - Magnetar

Problem highlighted in blue  - remove the space.

 

DavidP_0-1584401425765.png

 

Highlighted
5 - Atom

jjdenha_0-1584407868538.png

 

Why is it returning a Null?

Highlighted
Alteryx Certified Partner

@jjdenha - can you modify the [Length of Service 1] fields datatype to DOUBLE and test? If you still get a null, could you share a screenshot of the [Length of Service 1] field which is causing the null?

Highlighted
5 - Atom

Screen shot is above

Highlighted
Alteryx Certified Partner

@jjdenha - screenshot didnt come through. Can you upload it again?

Highlighted
5 - Atom

I did away with the 'and' and just used < for all of them problem solved

9 - Comet

I was going to suggest just a simple less than each time instead of (greater than x and less than y).

 

The formula runs from left to right, so if the first test is matched, the formula can stop processing. This means if LoS is <=90 it stops at the first test, Alteryx doesn't go on to test if it is ALSO less than 180.

 

If it isn't <=90, but it happens to be <=180 that condition wins then the formula doesn't move any further, and so on until the first occurrence of a test being passed, or the final else if none are passed.