Skip to main content
  • EN

Hi Everyone,

I hope that someone might be able to provide some guidance or suggestions on a task I am attempting with FME. My team is in the process of cleaning up our GIS data, and as part of this clean-up effort I have been asked to determine all of the records (from various attribute fields) that contain 9999 across all feature classes. So for example, Feature class A may have attributes in the 'Material' field with a value of 9999, Feature class B may have Diameter with 9999, Feature class C could have Install Year and Material with 9999, etc.. Is there a simple way to perform this task to search for all 9999 values across all feature classes? I would appreciate any assistance that could be provided!

 

Thank you,

Shelley

You could test all attributes with the attributevalidator, use contains regex and pass anything that doesn't equal 9999

^(?!9{4}$).*$

Any features that do equal 9999 will come out the failed port.

This presumes you have the workspace set up so you can select all attributes that exist across all featureclasses in the attribute validator

Reply


Community Stats

30,108
Posts
114,295
Replies
37,745
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.