1

I'm using ArcMap to tidy up some field collected point data. The point data is a sequential track from a handheld device. In the attribute table i have a field with differant activities that separate out each track. However, only the first occurrence/point of the activity is filled in and the rest below are blank till the next activity. .eg.

running

-

walking

-

Is there a way to filldown the entries to blank fields below? There are hundreds of blank entries for each one with a value, not sure if this makes a difference.

7

Assuming this structure:

enter image description here

create new field and run this field calculator expression on it:

def fillMe(text):
 global before
 if text=="-":
  return before
 else:
  before=text
  return before

-----------------------

fillMe( !CAT_DOG!)

enter image description here

  • This expression can be reduced by 2 lines by using <> in if statement. Current structure makes it easier to read – FelixIP Sep 1 '16 at 21:58
  • Could you elaborate on the "global before" ? Is the "before" item something dependent on the order of the FID field or can it be affected by the current order of the table ? To explain in an other way : if the table was ordered differently, would it change the way your code would work ? – gisnside Sep 15 '16 at 3:14
  • I believe arcgis works using physical records position, I.e. using FID – FelixIP Sep 15 '16 at 4:20
  • Have you read OP at all? My answer tailored to it. Feel free to post your own – FelixIP Sep 15 '16 at 4:31
  • Op is original post, question. It states an order of features and no mentioning of other fields. Thus no way to apply sorting – FelixIP Sep 15 '16 at 4:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.