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
SHAPE_LENG is a column title in this case
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
Note that this information is available in the following article in our Wiki: Using the WHERE clause and Duplicate option in ModelBuilder to filter imported data
Regards,
Jesse DringoliTechnical Support Manager, OpenFlowsBentley Communities Site AdministratorBentley Systems, Inc.