Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

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 🙂 

 

 

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