Join Repeats without Duplicates?

Storyteller1 — Sun, 24 Jul 2022 14:24:50 GMT

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.

Re: Join Repeats without Duplicates?

SMauri — Mon, 25 Jul 2022 12:49:58 GMT

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

Cheers

Stefano

topic Join Repeats without Duplicates? in ArcGIS Survey123 Questions

Join Repeats without Duplicates?

Re: Join Repeats without Duplicates?