I'm getting an error in a filter tool Invalid type in operator ==

[CherieACI]

I'm getting an error in a filter tool: Invalid type in operator ==. What does this mean? I have included a screen shot of the filter and I don't see any issues. We have been using this for months with no issues and now all of a sudden this error appears. 

Any ideas? Thanks!

[TheOC]

hi @CherieACI 

your error suggests that one of these columns is coming in as a string, and its a data type mismatch for the formula. Click on the results of the previous tool, and there should be a 'metadata' option in the results window:

Here you can see what type all of your fields are. I would suggest using a select tool to convert all of these fields to a numeric.

Cheers,
TheOC

[JosephSerpis]

Hi @CherieACI that means your data going through the filter dosen't match the criteria of the arguement you have in place. For example you check if a column = 0 which a numeric arguement if that column was a string instead then it will through invalid type.

[messi007 · Accepted solution]

@CherieACI,

Please check the columns [M1 Begin ...] they have to be Double.

Or if they are i string format you have to put the zero between "0".

Hope this helps !

Regards

[CherieACI]

That is exactly what the issue was. Thank you! 

[messi007]

@CherieACI,

Happy to help :)

Regards