Large dataset field population

Question

Please help! I need to populate a field in a statewide feature class (over 25 million records) based on four fields within the feature class. I'd like to be able to have it populate it using ModelBuilder or something since there are over 8,000 combinations of the 4 fields but I'm no coder. Here's what I'm essentially looking for:

If field1=a and field2=b and field3=c and field4=d, populate field5=e

Here's an example of the combinations from excel:

field1field2field3field4field5Well drainedABare LandForest36Well drainedABare LandRecreation39

DavidPike · Answer

could you just turn those field strings into coded values of 0 to 999 for example, then concatenate them

well drained = 002
A = 104

Bare Land = 065

Forest = 908

field 5 = 002104065908

well drained = 002
A = 104

Bare Land = 065

Recreation = 002

field 5 = 002104065002

DanPatterson_Retired · Answer

I would suggest examining the combinations first.

What are the combinations being used for... e.g. is a 'decision' being made based on a combination?

Are 8000 combinations really necessary?

How different are the combinations?

It would be a real waste of time and effort to have to aggregate at a later stage when you realize that some of the combinations weren't really necessary because of their similarity and influence on the 'end goal'

JoshuaBixby · Answer

If you have a table with all 8,000 combinations, I suggest making new composite keys in each table that combine the 4 fields together as a text string.  Then, join the two tables based on the composite key, and then run an update on the one table based on the joined values from the other table.

Another approach would be to load the 8,000 combination table into a nested Python dictionary and use a cursor to lookup values and update the field.  I think my first suggestion will be easier for you to implement.