https://community.esri.com/t5/arcgis-pro-ideas/include-quot-concatenate-distinct-quot-statistic/idi-p/1381460 <P>When using the Dissolve or Pairwise Dissolve GP tool, currently you have the option of choosing "Concatenate" as the Statistic Type for Statistic Fields.&nbsp;</P><P>IDEA: Add a "Concatenate Distinct" option so that when data is concatenated, you don't get repeating values.&nbsp;</P><P>Example:</P><P>A layer contains 8 rows with a text field with values from the following list: A, B, C, D (some values appearing more than once).&nbsp;</P><P>When Dissolving using that field as a Statistics field, the current "Concatenate" option returns "A, A, B, C, C, C, D, D" from the 8 rows into 1 dissolved row.&nbsp;</P><P>The proposed "Concatenate Distinct" option would only return "A, B, C, D" from the 8 rows.&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="LindsayRaabe_FPCWA_0-1707808485575.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/94573iEFCADEC8FBC7BD7F/image-size/medium?v=v2&amp;px=400" role="button" title="LindsayRaabe_FPCWA_0-1707808485575.png" alt="LindsayRaabe_FPCWA_0-1707808485575.png" /></span></P><P>&nbsp;</P> Tue, 13 Feb 2024 07:20:25 GMT LindsayRaabe_FPCWA 2024-02-13T07:20:25Z https://community.esri.com/t5/arcgis-pro-ideas/include-quot-concatenate-distinct-quot-statistic/idi-p/1381460 <P>When using the Dissolve or Pairwise Dissolve GP tool, currently you have the option of choosing "Concatenate" as the Statistic Type for Statistic Fields.&nbsp;</P><P>IDEA: Add a "Concatenate Distinct" option so that when data is concatenated, you don't get repeating values.&nbsp;</P><P>Example:</P><P>A layer contains 8 rows with a text field with values from the following list: A, B, C, D (some values appearing more than once).&nbsp;</P><P>When Dissolving using that field as a Statistics field, the current "Concatenate" option returns "A, A, B, C, C, C, D, D" from the 8 rows into 1 dissolved row.&nbsp;</P><P>The proposed "Concatenate Distinct" option would only return "A, B, C, D" from the 8 rows.&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="LindsayRaabe_FPCWA_0-1707808485575.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/94573iEFCADEC8FBC7BD7F/image-size/medium?v=v2&amp;px=400" role="button" title="LindsayRaabe_FPCWA_0-1707808485575.png" alt="LindsayRaabe_FPCWA_0-1707808485575.png" /></span></P><P>&nbsp;</P> Tue, 13 Feb 2024 07:20:25 GMT https://community.esri.com/t5/arcgis-pro-ideas/include-quot-concatenate-distinct-quot-statistic/idi-p/1381460 LindsayRaabe_FPCWA 2024-02-13T07:20:25Z https://community.esri.com/t5/arcgis-pro-ideas/include-quot-concatenate-distinct-quot-statistic/idc-p/1381464#M28468 <P>See this discussion for a work around using Arcade and Calculate Field which removes duplicate features after Concatenating values during Dissolves.&nbsp;</P><P><A href="https://community.esri.com/t5/arcgis-pro-questions/concatenate-distinct-values-with-dissolve/td-p/1222596" target="_blank">Solved: Concatenate Distinct Values with Dissolve - Esri Community</A></P> Tue, 13 Feb 2024 07:52:43 GMT https://community.esri.com/t5/arcgis-pro-ideas/include-quot-concatenate-distinct-quot-statistic/idc-p/1381464#M28468 LindsayRaabe_FPCWA 2024-02-13T07:52:43Z