Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Can you spot the error in my multi-row formula?

HelenL
8 - Asteroid

Line 3 works perfectly.

Why is it not recognising "Null" in Line 1 and 2.

Media and Magazine fields are both String. 

Thanks for looking :) 

 

 

5 REPLIES 5
HelenL
8 - Asteroid

Thanks for your quick reply.

I tried this but got the same result.


IF ([Media] = "Media" AND IsNull([Magazine])) THEN "Media"
ELSEIF (IsNull([Media]) AND [Magazine] = "Magazine") THEN "Magazine"
ELSEIF [Media] = "Media" AND [Magazine] = "Magazine" THEN "Media & Magazine"
ELSE "test"
ENDIF


jasperlch
12 - Quasar

Hi, for recognising Null Values, you will need to put IsNull([Media]), IsNull([Magazine]). By the way, you could probably use a normal Formula tool for your current formula.

jasperlch
12 - Quasar

That is strange as it works fine on my machine. Try using IsEmpty(Media) and IsEmpty(Magazine). IsEmpty function takes cells with a space or blank string as True as well. 

 

Capture1.PNG

 

Thanks,

Jasper

jasperlch
12 - Quasar

That is strange as it works fine on my machine. Try using IsEmpty(Media) and IsEmpty(Magazine). IsEmpty function takes cells with a space or blank string as True as well. 

 

Capture1.PNG

 

Thanks,

Jasper

jasperlch
12 - Quasar

Hi, another suggestion is to use the Transpose + Summarize tool. The method is more dynamic if you need to work on more than one fields other than "Media" and "Magazine'.

 

Capture1.PNG 

Labels