idea Arcade function to show unique values (remove duplicate values) in ArcGIS Pro Ideas

Arcade function to show unique values (remove duplicate values)

LindsayRaabe_FPCWA — Fri, 19 Feb 2021 01:42:28 GMT

When using the Table Attribute dynamic text function in ArcGIS Pro you can return a string of values visible in the map frame (i.e.1, 2, 3, 4,...). Sometimes you may have a dataset with multiple features with the same value (i.e.1, 2, 2, 2, 3, 3, 4,...).. By using this function in it's current format, you would see the results as per the example given, but sometimes you may want to only see Unique values (i.e. 1, 2, 2, 2, 3, 3, 4 would be returned as 1, 2, 3, 4). It would be good if there was an Arcade function that shows unique values, removing any duplicates (suggestion below).

This post is another example of where this function would be useful: https://community.esri.com/t5/arcgis-pro-questions/how-to-remove-duplicate-values-from-dynamic-text-attribute-value/m-p/1028309#M37611

Re: Arcade function to show unique values (remove duplicate values)

MehdiPira1 — Fri, 19 Feb 2021 01:51:13 GMT

Great idea @LindsayRaabe_FPCWA !

Re: Arcade function to show unique values (remove duplicate values) - Status changed to: Already Offered

CraigWilliams — Fri, 19 Feb 2021 02:44:13 GMT

You can put the values into an array and then use the Distinct function for this. This will work with numbers or text in an array, for example:

Distinct(["1", "2", "2", "2", "3", "3", "4"])

Distinct([1, 2, 2, 2, 3, 3, 4])

The Split function can help you construct an Array if you don't have one already.

Re: Arcade function to show unique values (remove duplicate values)

LindsayRaabe_FPCWA — Fri, 19 Feb 2021 02:55:17 GMT

@CraigWilliams I'm not sure this works correctly in the Dynamic Text function. As per screenshot below, I don't get any values returned - just the delimiter.

Re: Arcade function to show unique values (remove duplicate values)

LindsayRaabe_FPCWA — Sat, 20 Feb 2021 23:43:55 GMT

Support case lodged. #02745001 Removing duplicate values using DISTINCT arcade function in table value dynamic text not working

Re: Arcade function to show unique values (remove duplicate values)

LindsayRaabe_FPCWA — Wed, 24 Feb 2021 08:03:31 GMT

Just received this update;

"Thank you for your patience as we have investigated this issue. I just wanted to update you on this case. After extensive testing, it does appear that there is an issue with the Distinct function when used in the Table Attributes option for Dynamic Text. We were able to replicate this issue and found that a blank output was returned when applying the Distinct function as outlined in the Esri Community post that you sent through.

Because of this, we have lodged a bug on the issue BUG-000137676: Unable to remove duplicates using 'Distinct' Arcade function in Table Attribute Value Dynamic Text in ArcGIS Pro. "

Hopefully see a fix in 2.8!

Re: Arcade function to show unique values (remove duplicate values)

SamJeneCastro23 — Fri, 19 Nov 2021 16:35:30 GMT

@LindsayRaabe_FPCWA Is there a fix for this in 2.8.1?

Re: Arcade function to show unique values (remove duplicate values)

KoryKramer — Fri, 19 Nov 2021 21:45:38 GMT

The bug mentioned above is showing as In Product Plan on the support site: https://support.esri.com/en/bugs/nimbus/QlVHLTAwMDEzNzY3Ng==

Meaning that it is not fixed in 2.8.1 or the current version of Pro which is 2.9. But it looks like work is being done.

Re: Arcade function to show unique values (remove duplicate values)

LindsayRaabe_FPCWA — Sat, 20 Nov 2021 09:16:53 GMT

Not that I've figured out or that ESRI support has shown me. Not really satisfied with the explanation I got from them on this one.

Re: Arcade function to show unique values (remove duplicate values)

LindsayRaabe_FPCWA — Fri, 25 Nov 2022 04:40:05 GMT

Just looked into this - it's still in the Product Plan. Wish they would fix it already!

My Esri | Bug Details

Re: Arcade function to show unique values (remove duplicate values)

Zipster — Wed, 15 Feb 2023 22:06:36 GMT

I've been trying to make this work for three days and have just now discovered this is a bug.

Crickey. Two years to work on it and it isn't fixed yet? Git 'er done already.

Re: Arcade function to show unique values (remove duplicate values)

ZacharyHart — Thu, 16 Mar 2023 15:24:59 GMT

@KoryKramer @CraigWilliams

are there any updates from the Esri side of this? 2 years is a long time.

Being able to retrieve unique records from a field would be incredibly beneficial for map production!

Re: Arcade function to show unique values (remove duplicate values)

LindsayRaabe_FPCWA — Thu, 16 Mar 2023 23:57:29 GMT

Bug report still states "In Product Plan", so I'm going to assume no fixes are in place yet.

Re: Arcade function to show unique values (remove duplicate values)

KoryKramer — Fri, 17 Mar 2023 16:38:04 GMT

@ZacharyHart is is actively being worked on in the 3.2 development cycle right now.

Re: Arcade function to show unique values (remove duplicate values)

LindsayRaabe_FPCWA — Mon, 20 Mar 2023 04:21:07 GMT

@KoryKramer Welcome news! Can finally start tidying up our project layouts!

Re: Arcade function to show unique values (remove duplicate values)

jchester73 — Fri, 28 Apr 2023 12:28:51 GMT

Does anyone know whether this issue has been addressed in ArcGIS Pro 3?

Re: Arcade function to show unique values (remove duplicate values)

ZacharyHart — Fri, 28 Apr 2023 12:53:55 GMT

@jchester73No. See @KoryKramer response that it's in the product plan for 3.2.

I really wish this worked...I don't know how a function can be listed in the help guides starting several versions ago if it doesn't even work.

This would greatly improve our map production process. Right now in order to accomplish this, we have duplicated layers that are unsymbolized and have another clause in the definition query reference one unique record for a subject property. The various dynamic text elements reference this dummy layer in the TOC to do the labeling we need.

Re: Arcade function to show unique values (remove duplicate values)

LindsayRaabe_FPCWA — Wed, 03 May 2023 10:41:42 GMT

Just got this in an email from ESRI.

Updates have been made to the following defect which you are associated with:
BUG-000137676 - In ArcGIS Pro, unable to remove duplicates using the Distinct Arcade function in the Dynamic Text tool for table attribute values.

Status: Fixed (Learn More)
Version Fixed: 3.2
Additional Information: This issue is addressed in ArcGIS Pro 3.2.

Re: Arcade function to show unique values (remove duplicate values)

jakek — Fri, 14 Jul 2023 19:00:42 GMT

Has anyone been able to make this work? I'm using an Arcade calculate field expression, "Distinct($feature.CONCATENATE_subset_cd)" w/out quotes and repeatedly fails. Here is a sample of 65 values in a single field in a single row in the table (other rows have many more values in this field):

300,902,902,902,126,126,126,126,126,126,126,126,126,124,126,127,109,126,109,902,124,902,126,902,902,126,126,123,126,126,126,126,902.3

WARNING 001156: Failed on input OID 14, could not write value 'Unknown Object' to output field SubcodeUnique

Any suggestions?

I have also submitted a new idea to concatenate unique only values here: Concatenate Unique values (only) - Esri Community . Please upvote this idea! Thank you.

Re: Arcade function to show unique values (remove duplicate values)

LindsayRaabe_FPCWA — Mon, 17 Jul 2023 01:48:00 GMT

Nope - I still can't make it work either. Example below.

No Distinct expression:

With Distinct expression:

Tried it with a text field as well with the same results. I don't see how this has been fixed. Will try reopen my support ticket.