Excluding NULL values in Delete Identical geoprocessing tool

744
3
Jump to solution
08-21-2019 11:53 AM
by Anonymous User
Not applicable

I am using the Delete Identical tool in model builder to remove identical features using unique values in a specific field. In that field there are a few NULL values that are getting deleted since they are technically duplicates. Is there a way to add an expression or something similar so that the Delete Identical tool ignores NULL values and doesn't delete them? 

0 Kudos
1 Solution

Accepted Solutions
DanPatterson_Retired
MVP Emeritus

You might have to add a pre-step to select by attributes those attributes that are not Null, then the delete identical tool.

I would use the find identical tool for testing first though

Find Identical—Data Management toolbox | ArcGIS Desktop 

View solution in original post

3 Replies
DanPatterson_Retired
MVP Emeritus

You might have to add a pre-step to select by attributes those attributes that are not Null, then the delete identical tool.

I would use the find identical tool for testing first though

Find Identical—Data Management toolbox | ArcGIS Desktop 

by Anonymous User
Not applicable

Thank you, I was over thinking this one and forgot about select by attributes. 

0 Kudos
DuncanHornby
MVP Notable Contributor

To compliment Dan's answer you should know that ALL geo-processing tools honour selections first. So by applying a selection to a layer that is how you can process a subset of data.