Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- def findRevisit(): #Looks for revisited in the incoming data set using table join and DT(date) field. Flags potential revisits with '2' in QAQC_FLAG field.
- arcpy.env.workspace = inPGDB
- rtTbl = "midFCviewJoin_vw"
- leftTbl = in_table_view
- joinField = "UUID"
- dateField = "DT"
- updField = "QAQC_FLAG"
- fields = [joinField,dateField,updField]
- leftDate = in_table + "." + dateField
- rtDate = midFCview+ "." + dateField
- arcpy.AddJoin_management(leftTbl,joinField,rtTbl,joinField)
- ## arcpy.JoinField_management(leftTbl,joinField,rtTbl,joinField,"")
- sql = leftTbl + "." + joinField + " <> " + rtTbl + "." + joinField
- print "SQL where clause: " + sql
- with arcpy.da.UpdateCursor(leftTbl,[dateField,updField],sql) as cursor:
- for rec in cursor:
- rec[1]=2 ##Set QAQC flag = 2 for possible revisits in the incoming dataset
- cursor.updateRow(rec)
- print rec
- ## arcpy.DeleteField_management(in_table, "QAQC_FLAG_1")
- arcpy.RemoveJoin_management(leftTbl)
- return leftTbl,rtTbl,sql
- del cursor,rec
- Traceback (most recent call last):
- File "C:/Users/kgaines/Documents/Aquadat/Scripting/AquaDat_tableCreate_findDup_findRevisit_defFunct.py", line 232, in <module>
- main()
- File "C:/Users/kgaines/Documents/Aquadat/Scripting/AquaDat_tableCreate_findDup_findRevisit_defFunct.py", line 225, in main
- findRevisit()
- File "C:/Users/kgaines/Documents/Aquadat/Scripting/AquaDat_tableCreate_findDup_findRevisit_defFunct.py", line 169, in findRevisit
- for rec in cursor:
- RuntimeError: Too few parameters. Expected 2.
- def findRevisit():
- arcpy.env.workspace = inPGDB
- r_Table = "midFCviewJoin_vw"
- l_Table_view = in_table_view
- arcpy.MakeTableView_management(r_Table, r_Table_view) #assuming that the left table is already 'table view'
- #Joining Tables
- arcpy.AddJoin_management(l_Table_view, "UUID", r_Table_view, "UUID")
- #Create a table view out of joined tables
- arcpy.MakeTableView_management(l_Table_view, joined_table)
- fields = ["UUID", "DT", "QAQC_FLAG"]
- sql = '"UUID" <> "UUID"'
- #Here I assume you are saying: Change DT value to 2
- with arcpy.da.UpdateCursor(joined_table, fields, sql) as cursor:
- for rec in cursor:
- rec[1] = 2 ##Set QAQC flag = 2 for possible revisits in the incoming dataset
- cursor.updateRow(rec)
- print rec
- arcpy.RemoveJoin_management(joined_table)
- return l_Table_view, r_Table_view, sql
- del cursor, rec
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement