I have a 'feature class' that I want to import but this one in the 'FIFTINGTYPE' column has specifically a type that I do not want to import, how could I use the 'WHERE' clause ?.Could you please help me with the operator 'AND' and 'NOT', by means of an example is that I usually make a mistake in the use of '', [].
Hi Albert,
If you have just one type you want to exclude, you could use this:
FITTINGTYPE <> 'type'
If you have multiple you want to exclude, you can use this syntax:
FITTINGTYPE not in ('type1', 'type2')
Some additional information can be found in the documentation:
https://docs.bentley.com/LiveContent/web/Bentley%20WaterCAD%20CONNECT%20Edition%20Help-v1/en/GUID-57FF6E0A-A271-4040-85AB-27830321D989.html
Best regards,
Rob.
Thank you very much Rob for helping me, I really appreciate your time.
Hello Albert,
In addition to Rob's specific response to using the NOT and AND operators, I am sharing a general article which you can use as a reference when using the WHERE clause with ModelBuilder;
Using the WHERE clause and Duplicate option in ModelBuilder to filter imported data
Hope this helps.
Regards,
Yashodhan Joshi