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!
Solved! Go to Solution.
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
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.
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
That is exactly what the issue was. Thank you!