How to remove duplicate values from Dynamic Text (Attribute Value)
Hi,
I'm trying to use as much dynamic text as I could for our maps. I wanted to get rid of duplicate Township labels and just show 1 value.
Thanks
If you were only wanting to show 1 value (i.e. 80 but not 79 in your image above), then I'd say yes. I too struggled with this for a while. The solution I found was to add a section of spaces (i.e. " ") to the delimiter field. This essentially added a big gap between the first and second value, resulting in the second value not fitting in the frame. The trick was putting in enough spaces to bump out the next value based on the shortest value you wanted to display (i.e. "Word" instead of "Reallylongword"). If you had enough spaces to fill the gap between two lots of "Reallylongword", but not enough to fill the gap between two "Word" values, you could still end up seeing "Word Word". The other neat little part of this was that the text justification was based on the values displayed (i.e. it would still centre the "Word" and not factor in the delimeter). See below for clarity.
Unfortunately, I don't think this will work for you, as it looks like you have multiple features with the same value (i.e. 80) and therefore, you wouldn't be able to get it to discriminate between values. Arcade doesn't seem to have a solution either (no "remove duplicates" text function which would be really nice to see). I tried using the DISTINCT function but that didn't work either. It returns an array, which doesn't translate into a string, and when I tried to convert the array to a string, it just gave me what we started with.
Hi!
You should be able to get what you want by changing your query. Instead of visible rows, try using Custom Query to build a query for just the feature you want to show.
Or, if you are using a map series the Map Series Row option will only the value from the map series index layer, not all the other values.
Cheers,
Aubri
