Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
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.

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