nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Concatenate Distinct Values with Dissolve

NathanBaier1

I am using the concatenate function in the dissolve tool but need the output results to be distinct. Where the concatenate would yield A, B, B, C, D I would want the result to remove the duplicated B. A, B, C. If you run this gp tool via python is there a way to add a distinct function to the code?

Find more posts tagged with

Accepted answers

NathanBaier1

here is the solution:

var field = $feature.CONCATENATE_Acquisition_Source
var spfield = Split(field,"; ")
var dist = distinct(spfield)
return Concatenate(dist, "; ")

All comments

LindsayRaabe_FPCWA

Perfect! Just what I needed 🙂

NathanBaier1

here is the solution:

var field = $feature.CONCATENATE_Acquisition_Source
var spfield = Split(field,"; ")
var dist = distinct(spfield)
return Concatenate(dist, "; ")

NathanBaier1

this expression ran but it did not produce the desired result. Instead of cleaning out it created a bunch of new coma delimited data.

danretired

expression
func(!CONCAT....!)  # enter your field name... too long for me to type

code block

def func(a):
    return ", ".join(sorted(list(set(a.replace(" ", ""))))[1:])

NathanBaier1

I have been trying that and I cannot get the format to work. Not sure if I have this formatted correct but when I make a = field I get an invalid syntax.

danretired

It is a field calculator expression and when I mean replace `a` in the expression, then I mean substitute it with your field name

NathanBaier1

When I run this through notebook here is what it looks like:

Do I need to define the dataset prior to the field?

NathanBaier1

I am not sure how to apply this code. Through notebook or field calculator? Would this apply to each row in a table?

danretired

using as many python functions as I can 😉

a = 'A, B, B, C, D'
z0 = ", ".join(sorted(list(set(a.replace(" ", ""))))[1:])
z0
'A, B, C, D'

you will have to replace `a` with !YourFieldName! with the ! marks

If the string is formatted differently you can modify to suit

NathanBaier1

Another option would be a field calculator after the gp tool that remove duplicates from the text string.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.