topic Re: Excluding NULL values in Delete Identical geoprocessing tool in ModelBuilder Questions https://community.esri.com/t5/modelbuilder-questions/excluding-null-values-in-delete-identical/m-p/851012#M1128 <HTML><HEAD></HEAD><BODY><P>To compliment Dan's answer you should know that ALL geo-processing tools honour selections first. So by applying a selection to a<EM> layer</EM> that is how you can process a subset of data.</P></BODY></HTML> Thu, 22 Aug 2019 10:55:41 GMT DuncanHornby 2019-08-22T10:55:41Z Excluding NULL values in Delete Identical geoprocessing tool https://community.esri.com/t5/modelbuilder-questions/excluding-null-values-in-delete-identical/m-p/851010#M1126 <HTML><HEAD></HEAD><BODY><P>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?&nbsp;</P></BODY></HTML> Wed, 21 Aug 2019 18:53:00 GMT https://community.esri.com/t5/modelbuilder-questions/excluding-null-values-in-delete-identical/m-p/851010#M1126 Anonymous User 2019-08-21T18:53:00Z Re: Excluding NULL values in Delete Identical geoprocessing tool https://community.esri.com/t5/modelbuilder-questions/excluding-null-values-in-delete-identical/m-p/851011#M1127 <HTML><HEAD></HEAD><BODY><P>You might have to add a pre-step to select by attributes those attributes that are not Null, then the delete identical tool.</P><P>I would use the find identical tool for testing first though</P><P><A class="link-titled" href="https://pro.arcgis.com/en/pro-app/tool-reference/data-management/find-identical.htm" title="https://pro.arcgis.com/en/pro-app/tool-reference/data-management/find-identical.htm">Find Identical—Data Management toolbox | ArcGIS Desktop</A>&nbsp;</P></BODY></HTML> Wed, 21 Aug 2019 20:24:05 GMT https://community.esri.com/t5/modelbuilder-questions/excluding-null-values-in-delete-identical/m-p/851011#M1127 DanPatterson_Retired 2019-08-21T20:24:05Z Re: Excluding NULL values in Delete Identical geoprocessing tool https://community.esri.com/t5/modelbuilder-questions/excluding-null-values-in-delete-identical/m-p/851012#M1128 <HTML><HEAD></HEAD><BODY><P>To compliment Dan's answer you should know that ALL geo-processing tools honour selections first. So by applying a selection to a<EM> layer</EM> that is how you can process a subset of data.</P></BODY></HTML> Thu, 22 Aug 2019 10:55:41 GMT https://community.esri.com/t5/modelbuilder-questions/excluding-null-values-in-delete-identical/m-p/851012#M1128 DuncanHornby 2019-08-22T10:55:41Z Re: Excluding NULL values in Delete Identical geoprocessing tool https://community.esri.com/t5/modelbuilder-questions/excluding-null-values-in-delete-identical/m-p/851013#M1129 <HTML><HEAD></HEAD><BODY><P>Thank you, I was over thinking this one and forgot about select by attributes.&nbsp;</P></BODY></HTML> Thu, 22 Aug 2019 13:29:16 GMT https://community.esri.com/t5/modelbuilder-questions/excluding-null-values-in-delete-identical/m-p/851013#M1129 Anonymous User 2019-08-22T13:29:16Z