ModelBuilder - automatic rename attributes in table

StanislavaV

Hi, 

I have another question for today - automatic renaming values in ModelBuilder?

My table have attributes looks like this:

FID      CODE        CODE2

1           1001              1

2           1001              1

3            2000             1

4            2000             1

5             2000            1

...........and so on.

And my goal is - that column CODE2 will be automatically calculated.

So, there are two polygons with CODE 1001 but CODE2 is different for each of these.

FID      CODE        CODE2

1           1001              1

2           1001              2

3            2000             1

4            2000             2

5            2000            3

.....

Is there some possibility to do this?

Thank you.

 

DavidPike

OK, so run a field calculator ensuring that Python is chosen as the expression type.

pre-logic script code/ Code block:

CODE_dict = {}
def auto_increment(field):
    global CODE_dict
    if field in CODE_dict.keys():
        CODE_dict[field] += 1
        return CODE_dict[field]
    else:
        CODE_dict[field] = 1
        return 1
        

to run it using that function:

auto_increment(!CODE!)

The code block creates a global dictionary to store a key of the CODE against an increment.  If no key exists in the dictionary, the key(CODE) is added to it, with a value of 1.  This is also then returned by the function.

If the key(CODE) does exist in the dictionary, the value is then incremented by 1, and that value returned.