Alteryx Designer Discussions

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

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
SOLVED

Invalid type in operator ==

Highlighted
8 - Asteroid

Hi

 

I am getting an Invalid type in operator == error on a tool and I don't know why. I did use the ToNumber() formula to see if that is causing the issue but I still see the issue.


Can someone help resolve it?

 

Thanks,

Christine

 

cwoo_0-1581615079533.png

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Is the [Period] field a string? If not, remove the quotes around the values and give that a try.

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

@cwoo ,

 

Please check to see if [Period] is a string data type.  If it isn't, then remove the quotes from 1,2,3,4.

Also,  your ELSE statement is putting "" into a DOUBLE field.  That should probably be:

 

ELSE NULL()

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

@CharlieS ,

 

Great minds think alike.  Very loose definition of great.

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Highlighted
8 - Asteroid

That did the trick. Thanks!

The [Period] field was an integer.

 

Thanks,

Christine

Labels