https://community.esri.com/t5/arcgis-pro-ideas/data-engineering-select-duplicate-records-or/idi-p/1212173 <P>Within the Data Engineering Pane, it would be great if the duplicate/unique field had enhanced functionality to either select the duplicates (as you can select other values of interest in the other fields) or to encode a value of 0/1 to identify a duplicate entry through the creation of a new field.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="feralcatcolonist_0-1663099321811.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/51081iE9C53411F4FF4232/image-size/medium?v=v2&amp;px=400" role="button" title="feralcatcolonist_0-1663099321811.png" alt="feralcatcolonist_0-1663099321811.png" /></span></P><P>Encode field is less useful for this task as it creates a field per unique entry; instead, there could be a binary option (0 == unique, 1 == duplicate).</P><P>Examples of similar workflows:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="feralcatcolonist_5-1663099552289.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/51087iEDC0572219A45682/image-size/medium?v=v2&amp;px=400" role="button" title="feralcatcolonist_5-1663099552289.png" alt="feralcatcolonist_5-1663099552289.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="feralcatcolonist_2-1663099489138.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/51084i34BF2F696DE3E80F/image-size/medium?v=v2&amp;px=400" role="button" title="feralcatcolonist_2-1663099489138.png" alt="feralcatcolonist_2-1663099489138.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="feralcatcolonist_4-1663099519091.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/51086i6CC04A79AE9D0DDB/image-size/medium?v=v2&amp;px=400" role="button" title="feralcatcolonist_4-1663099519091.png" alt="feralcatcolonist_4-1663099519091.png" /></span>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="feralcatcolonist_6-1663099584298.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/51088i7516D163BFC3105E/image-size/medium?v=v2&amp;px=400" role="button" title="feralcatcolonist_6-1663099584298.png" alt="feralcatcolonist_6-1663099584298.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 14 Sep 2022 13:04:05 GMT feralcatcolonist_old 2022-09-14T13:04:05Z https://community.esri.com/t5/arcgis-pro-ideas/data-engineering-select-duplicate-records-or/idi-p/1212173 <P>Within the Data Engineering Pane, it would be great if the duplicate/unique field had enhanced functionality to either select the duplicates (as you can select other values of interest in the other fields) or to encode a value of 0/1 to identify a duplicate entry through the creation of a new field.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="feralcatcolonist_0-1663099321811.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/51081iE9C53411F4FF4232/image-size/medium?v=v2&amp;px=400" role="button" title="feralcatcolonist_0-1663099321811.png" alt="feralcatcolonist_0-1663099321811.png" /></span></P><P>Encode field is less useful for this task as it creates a field per unique entry; instead, there could be a binary option (0 == unique, 1 == duplicate).</P><P>Examples of similar workflows:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="feralcatcolonist_5-1663099552289.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/51087iEDC0572219A45682/image-size/medium?v=v2&amp;px=400" role="button" title="feralcatcolonist_5-1663099552289.png" alt="feralcatcolonist_5-1663099552289.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="feralcatcolonist_2-1663099489138.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/51084i34BF2F696DE3E80F/image-size/medium?v=v2&amp;px=400" role="button" title="feralcatcolonist_2-1663099489138.png" alt="feralcatcolonist_2-1663099489138.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="feralcatcolonist_4-1663099519091.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/51086i6CC04A79AE9D0DDB/image-size/medium?v=v2&amp;px=400" role="button" title="feralcatcolonist_4-1663099519091.png" alt="feralcatcolonist_4-1663099519091.png" /></span>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="feralcatcolonist_6-1663099584298.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/51088i7516D163BFC3105E/image-size/medium?v=v2&amp;px=400" role="button" title="feralcatcolonist_6-1663099584298.png" alt="feralcatcolonist_6-1663099584298.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 14 Sep 2022 13:04:05 GMT https://community.esri.com/t5/arcgis-pro-ideas/data-engineering-select-duplicate-records-or/idi-p/1212173 feralcatcolonist_old 2022-09-14T13:04:05Z