0

How to select a row in ModelBuilder if a number appears again in the column "MyName_C"?

enter image description here

For the selected features the column "Ausrichtung" should be added with 180.

I am working with ArcGIS Desktop 10.6.

PolyGeo
  • 65,136
  • 29
  • 109
  • 338
nora
  • 131
  • 8
  • Create new integer type field and populate it using field calculator expression from https://gis.stackexchange.com/questions/200150/auto-incrementing-field-based-on-groups-within-feature-class/200154#200154 select everything with group number>1. – FelixIP Aug 26 '19 at 21:35
  • I will try it, thank you. – nora Aug 27 '19 at 07:49

1 Answers1

1

You could use the tool select by attribute with this query :

[FIELD_NAME] In (SELECT [FIELD_NAME] FROM [TABLE_NAME] GROUP BY [FIELD_NAME] HAVING Count(*)>1 )

Replace FIELD_NAME and TABLE_NAME as necessary.

Warning: The procedure outlined is not available for data stored in file geodatabase or shapefile formats.

Documentation : https://support.esri.com/en/technical-article/000006708

You could then use the calculate field with the option to calculate only selected to add 180 to your "Ausrichtung" column.

This procedure should work as separate steep or with the tool linked in a model.

As Nora point out there is a python solution that should work on any storage type (but only from version 10.0 and up as python expression are not supported in earlier version)

this work by creating a new field (short or long integer) that will be filled by 0 for single occurrences and the first occurrence of multiple values, duplicates are filled with 1.

the code block to use is :

uniqueList = []
def isDuplicate(inValue):
  if inValue in uniqueList:
    return 1
  else:
    uniqueList.append(inValue)
    return 0

full procedure : https://support.esri.com/en/Technical-Article/000012758

J.R
  • 16,090
  • 1
  • 19
  • 52
  • Thank you for your answer, unfortunately I need to working in a file geodatabase or with shapefiles. The solution is here: https://support.esri.com/en/Technical-Article/000012758 Thanks for your answers! – nora Aug 27 '19 at 07:49
  • @nora i'll update my answer with your comment so other could find a complete solution – J.R Aug 27 '19 at 08:19