Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

No Macro Issue-but on inserting in workflow I get the Invalid type of operator == error

Shaina1
8 - Asteroid

Hi,
I'm running a macro -which is running smoothly, but when I insert it in my workflow I get this error- Parse Error at char(5): Invalid type in operator ==-which refers back to the filter tool I have used in my macro. Attaching the filter tool I used. The metadata of this Field F7 is V_String-really not sure why this error is taking place. I tried debugging the macro as well-it is running smoothly. Used data cleaning tool as well for removing trailing whitespace-but don't think is causing any errors.

Apologies-I can't attach the workflow as it contains confidential information.

2 REPLIES 2
IraWatt
17 - Castor
17 - Castor

Hey @Shaina1 

When the data is read into the macro the meta data must be being read in with the wrong type, does adding a select and force that column to be a string before the filter work?

Shaina1
8 - Asteroid

Hey, I figured out the error actually-I was using attaching the macro to the wrong side of filter tool. Unfortunately cannot delete this post-but thanks a ton for responding back !

Labels
Top Solution Authors