I'm going to be as descriptive as possible. I have a table (TA) with values which are null for some rows, filled out for others. I have a table (TB) with the null values filled out.
Dec in TA is the shared value in TB (called Nulled in that table)
I can't do a table join because this would duplicate the amount of nulled columns in the first table. The gist of what I want it to do is this: if CURR_TYPE (one of the columns) is null in TA, lookup its Dec value, go to TB, look for the same value under Nulled, copy TB's CURR_TYPE, and paste it onto TA's CURR_TYPE.
This is what I have so far, and I've tried variations on things I've found here, but I get lost with how to tell python to LOOKUP in another field, copy and
# Import arcpy module
import arcpy
# Local variables:
TA = "F:...\\TA"
TB = "F:...\\TB"
TLDisNull = arcpy.AddFieldDelimiters(TA, "SponsorOrganization") + " IS NULL"
#Update rows
with arcpy.da.UpdateCursor(TA, "CURR_TYPE", TLDisNull) as u_cursor:
with arcpy.da.SearchCursor(TA, "Dec") as s_cursor1:
for s_row in s_cursor1:
with arcpy.da.SearchCursor(TB, "Nulled") as s_cursor2:
for s_row in s_cursor2