I have both a dbf that I need to check values against for a shapefile. I need to report whether the values match the dbf in the shapefile and if not, what the value should have been (in two new fields) So here's what I have:
-DBF (correct values for all unique combinations of two fields reported in a third field), sort of like a look up table. For each unique value within field A and B, there is a value in field C.
-A shapefile to check the value in field C against the dbf based off fields A & B within that shapefile.
I know a very inefficient work-around (concatenating fields then manually joining them), but I'm trying to get more familiar with modelbuilder and python. I prefer using modelbuilder so if this can be done in modelbuilder with maybe just a python field calculate (simple if then statement) that would be ideal.
I have very little Python knowledge and limited modelbuilder knowledge (basically I know how to drag and drop geoprocessing tools and set up parameters, but I struggle with the iterators and loops)
Thanks in advance
أكثر...
-DBF (correct values for all unique combinations of two fields reported in a third field), sort of like a look up table. For each unique value within field A and B, there is a value in field C.
-A shapefile to check the value in field C against the dbf based off fields A & B within that shapefile.
I know a very inefficient work-around (concatenating fields then manually joining them), but I'm trying to get more familiar with modelbuilder and python. I prefer using modelbuilder so if this can be done in modelbuilder with maybe just a python field calculate (simple if then statement) that would be ideal.
I have very little Python knowledge and limited modelbuilder knowledge (basically I know how to drag and drop geoprocessing tools and set up parameters, but I struggle with the iterators and loops)
Thanks in advance
أكثر...