Select to view content in your preferred language

Include "Concatenate Distinct" Statistic Type for Dissolve GP Tools

418
1
02-12-2024 11:20 PM
Status: Open
Labels (1)
LindsayRaabe_FPCWA
Honored Contributor

When using the Dissolve or Pairwise Dissolve GP tool, currently you have the option of choosing "Concatenate" as the Statistic Type for Statistic Fields. 

IDEA: Add a "Concatenate Distinct" option so that when data is concatenated, you don't get repeating values. 

Example:

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). 

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. 

The proposed "Concatenate Distinct" option would only return "A, B, C, D" from the 8 rows. 

LindsayRaabe_FPCWA_0-1707808485575.png

 

1 Comment
LindsayRaabe_FPCWA

See this discussion for a work around using Arcade and Calculate Field which removes duplicate features after Concatenating values during Dissolves. 

Solved: Concatenate Distinct Values with Dissolve - Esri Community