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