topic Re: Increment fields with null values in Data Management Questions

Increment fields with null values

steveubert — Tue, 02 Aug 2016 15:47:10 GMT

Hello,

I have a question about using python to auto increment numbers. I have a dataset with a range of numbers already defined (ID : 396548 - 410342) and (ID2 : 392988 - 406624). When I merged data I had fields that carried over 'Null' values. I do not want to change the known numbers, just the null values.

Here is a sample of my table, I have 27k fields with 13k numbered and the rest 'null'

ID	ID2
null	null
null	null
396548	392988
410342	406642

I'm using

rec=0

def autoIncrement():

global rec

pStart = 1 pInterval = 1

if (rec == 0):

rec = pStart

else:

rec += pInterval

return rec

ID =

autoIncrement()

I've tried chaging 'rec' to the starting number (ID:396548), but it changes all numbers.

Am I using the right option or is there a better one out there

Re: Increment fields with null values

DanPatterson_Retired — Tue, 02 Aug 2016 15:52:23 GMT

field calculations apply to all OR just a selection in the table... did you try selecting the records/rows that you want to change, then do the field calculation? You are also going to have to change 'rec' to be the first number that you want changed, otherwise, it will increment from 0

Re: Increment fields with null values

steveubert — Tue, 02 Aug 2016 16:02:49 GMT

I glossed over that little aspect. thanks for the help. I hate over thinking/looking simple things.