I have a polygon shapefile that represents combinations of soil hydrologic type (A,B,C,D) and soil cover (53 different possible covers, coded from 0 to 53). Each of the 53 soil covers can be either soil hydrologic type "A", "B", "C" or "D". Depending on this, each intersection will have assigned a number, i.e. field "CNII". I would like to populate CNII field automatically based on a table that looks like this:
My attribute table containing fields "Cod_Cob" (Integer) and "Clase_Hid" (Text) would need to have "CNII" (Integer) populated as a function of the former two:
I am new to Python parse in the field calculator (I am using Arcmap 10.4.1 with Standard License) but would like help finding a solution using this tool or any other kind you think is appropriate. I checked how to write if else statements and return the values input manually in the code but this doesn't seem adequate because there are more than 200.000 possible combinations for the soil type-soil cover complexes. I have 85 features I need to populate and I can do it manually by now, but I will be needing this solution for bigger projects.