This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Where statement in model builder

Out of a long list of pipes  i want to only import 3 specific pipes. Is that possible with the Where statement?

Becasue i tried entering the following query and it did not work: 

Query entered was:   SHAPE_LENG=74.879885395 AND SHAPE_LENG=189.519184877 AND SHAPE_LENG=1.43474052233

Parents Reply
  • Hi Christen,

    You would want to use OR in your statement. However, floating point numbers that go out to so many decimal places are going to be next to impossible to match exactly. You will be better off using a different column. Perhaps something like this: Label IN ('P-1', 'P-2', 'P-3')

    Rob.

    Answer Verified By: Christen Crique 

Children