ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Invalid type in operator ==

cwoo
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

 

CharlieS
17 - Castor
17 - Castor

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

MarqueeCrew
19 - Altair
19 - Altair

@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.
MarqueeCrew
19 - Altair
19 - Altair

@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.
cwoo
8 - Asteroid

That did the trick. Thanks!

The [Period] field was an integer.

 

Thanks,

Christine

Labels