Join Repeats without Duplicates?

373
1
07-24-2022 07:24 AM
Storyteller1
New Contributor

I'm creating a survey with ten collection points, and each collection point is a repeat. 

I'm trying to collect the total bird species that are at each point AND then a total of species from all 10 points.

For the individual repeats, I am using

join(', ', ${species1})

 

For the total count, I am using: 

join(', ', ${species1} + ${species2} + ${species3} + ${species4} + ${species5} + ${species6}  + ${species7} + ${species8} + ${species9} + ${species10})

This pulls in every species, but if one species at each point, it will be listed ten times.

Is there a way to remove the duplicates and, if possible, add spaces between answers? 

I've tried various attempts to play with the field string and bind options, but I am lost. 

 

 

0 Kudos
1 Reply
SMauri
by
Occasional Contributor III

How about using sum function, you can find at following page: Formulas—ArcGIS Survey123 | Documentation

SMauri_0-1658753289547.png

Cheers

Stefano

0 Kudos