Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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