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

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!

Workflow

Error Message

Accepted answers

messi007

@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

All comments

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

@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!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703