I am working with a ESRI file geodatabase.
I would like to test if cetain field contains a specific value from a lookup table (in an ideal world this testing would not be required as this would have been mitigated agaist by using domains - however I am where I am!).
So essentially I have two tables, first my feature class: Roads_FC
[ID],[RoadName],[RoadType]
1,High Street, Sealed Road
2,School Lane, Unsealed
3,Smith Road, Concrete Slabs
4,Jones Street, Sealed Road
5,Downy Street, Tarmac
6,Boris Street, Tarmac
My second table is a CSV 'FieldList' constructed as follows:
[FeatureClass],[Field],[RoadTypeVaL]
Roads_FC,RoadType,Concreate Slabs
Roads_FC,RoadType,Sealed Road
Roads_FC,RoadType,Unsealed
Rivers,RiverType,Main River
Rivers,RiverType,Medium River
Rivers,RiverType,Small River
So I want a test that tells me that items 5 and 6 do not contain a conrrect value from my field list (i.e. "Tarmac" is not a valid value).
I can filter 'FieldList' easily using a 2 testers - first to filter by the feature class I am testing, and secondly by the field I am testing. However I cannot work how to then check if the current row in my Roads Feature classe has one of my filtered values in 'FieldList'.
Can anyone help?
Regards,
Kevin
