Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.
SOLVED

Invalid type in operator ==

Highlighted
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

 

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
Asteroid

That did the trick. Thanks!

The [Period] field was an integer.

 

Thanks,

Christine

Labels