93 reputation
5
bio website
location
age
visits member for 5 months
seen 2 days ago
stats profile views 97

2d
comment Python Code: “Compare two fields and select missing records”
Sorry, but there was no new layer that was created and it still gave no sign of where the problem is and why it keeps selecting more records than are missing. I just realized I was putting in your name in front of message wrong.
2d
comment Python Code: “Compare two fields and select missing records”
Sorry, but there was no new layer that was created and it still gave no sign of where the problem is and why it keeps selecting more records than are missing.
2d
comment Python Code: “Compare two fields and select missing records”
Sorry, it didn't work. It should have only selected about 100 and it selected 800. It still is selecting records that are in the table. It should only be selecting those that are missing.
2d
comment Python Code: “Compare two fields and select missing records”
Thanks, Sorry I misunderstood.
2d
comment Python Code: “Compare two fields and select missing records”
@PolyGeo No, How do you do that??
2d
comment Python Code: “Compare two fields and select missing records”
So I did try to drop the Switch selection but it still selected records that were not missing????
2d
asked Python Code: “Compare two fields and select missing records”
Apr
25
awarded  Editor
Apr
25
revised Error: Exception Raised on the “for row in rows” command line?
deleted 10 characters in body
Apr
25
comment Error: Exception Raised on the “for row in rows” command line?
I looked on Desktop Help and it looks like I have the SelectLayer typed right. I'm not understanding what I'm missing.
Apr
25
comment Error: Exception Raised on the “for row in rows” command line?
Now, I got it to get at least down to the SelectLayerByAttribute line. It's giving me an invalid expression. So I have that line of code typed out wrong right?
Apr
25
comment Error: Exception Raised on the “for row in rows” command line?
So, to fix this would I also reference the field in the same area and then add an IF statement?import arcpy, traceback FRows = arcpy.SearchCursor(flayer) ARows = arcpy.SearchCursor(alayer) ffields = arcpy.ListFields(flayer, "", "FLAG") afields = arcpy.ListFields(alayer, "", "TFLAG") FList = [] AList = [] for row in FRows: for field in ffields: Fvalue = row.getValue("FLAG") FList.append(str(Fvalue)) for row in ARows: for field in afields: Avalue = row.getValue("TFLAG") AList.append(str(Avalue))
Apr
25
comment Error: Exception Raised on the “for row in rows” command line?
@blah238 Yes, it is. My boss wanted us to make sure people know what folder to not get into. LOL I actually fixed the Listfields problem. My row in FRows command line is still not working. I'm thinking it's missing an IF. When I add the script tool to a toolbox in ArcMAP with no parameters. I get Error:999999????
Apr
25
asked Error: Exception Raised on the “for row in rows” command line?
Apr
19
comment Python code: Using Search Cursor to find missing values in attribute table between two layers in one MXD
OK, when I took the da out. I get an IOError:Unknown. One idea I just had, this should probably run off the layer names. They are always named AADT, AADTAnnoLabel. Let me explain. My boss has asked me to write scripts to make one guys job easier because of how many times stuff has not been right. So, he built his maps wrong in the beginning, and has all his annotation in different gdbs. Don't ask!!! So, I'll try changing it to layers in the code. Please help if you have time. Thanks!!
Apr
19
comment Python code: Using Search Cursor to find missing values in attribute table between two layers in one MXD
When I run it in ArcMAP Python window, it says object has no attribute 'da'.
Apr
19
comment Python code: Using Search Cursor to find missing values in attribute table between two layers in one MXD
I am getting an exception raised. But I can't get it to highlight the row it has trouble with. I've tried toggle breakpoint and then step over. What else should I try?
Apr
17
asked Python code: Using Search Cursor to find missing values in attribute table between two layers in one MXD
Apr
8
awarded  Commentator
Mar
11
awarded  Scholar