community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

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

Meteor

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 :) 

 

 

Meteor

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


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.

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

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

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