AnsweredAssumed Answered

Increment fields with null values

Question asked by Subert81 on Aug 2, 2016
Latest reply on Aug 2, 2016 by Subert81

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'

IDID2
nullnull
nullnull
396548392988
410342406642

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

Outcomes