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

Question

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.

Error Message.PNG

Filter tool.PNG

Shaina1 · Answer

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 !

IraWatt · Answer

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?