How to create a list of unique strings, and print that list in a field using ArcGIS Pro field calculator

Question

I have a landcover polygon that I spatially joined to a soils polygon. This left me with many duplicate soil types in each row of the landcover polygon. I would like to summarize the soil types to only show a list of unique string values. How would I go about doing this in the field calculator?

Answer 1

With Field calculator and python parser:

Convert the string to a list with split

Convert the list to a set, which cant have duplicates

Join the set into a string

def nodups(soilnames):
    return ', '.join(set(soilnames.split(', ')))

Call with:

nodups(!Soil Names!)