https://community.esri.com/t5/arcgis-online-questions/how-to-return-distinct-values-from-a-related-table/m-p/1392933#M57972 <P>There is a <A href="https://developers.arcgis.com/arcade/function-reference/array_functions/#distinct" target="_self">Distinct</A> function available in Arcade you can use to do this, however, you need to have an&nbsp;<A href="https://developers.arcgis.com/arcade/function-reference/array_functions/#array" target="_self">Array</A>&nbsp;to return the unique values from. If you populate your result values into an array, you can use the Distinct function to return the unique results.</P><P>If you are happy with returning an array, then you can use the script below:</P><P>&nbsp;</P><LI-CODE lang="javascript">var fs = FeatureSetByName($map, "returnDistinct" , ['*'], false); var fsArray = Array(1); var fsCount = Count(fs); // check for features if (fsCount &gt; 0) { for (var f in fs) { // for each feature, add to the array Push(fsArray, f.name) } } else { return "No records available"; } // return distinct values return Distinct(fsArray);</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>If you prefer to return a text string instead, I modified the script slightly so that you can do that too. Just noting however that the first line returned is a "null" value creating an empty first line, which is why I've also added an Erase function to remove the 0 index.</P><P>&nbsp;</P><P>&nbsp;</P><LI-CODE lang="javascript">var fs = FeatureSetByName($map, "returnDistinct" , ['*'], false); var fsArray = Array(1); var fsCount = Count(fs); // check for features if (fsCount &gt; 0) { for (var f in fs) { // for each feature, add to the array Push(fsArray, f.name) } } else { return "No records available"; } // return distinct values // return Distinct(fsArray); // return distinct values text Erase(fsArray, 0); // remove 0-index "null" field return Concatenate(Distinct(fsArray), TextFormatting.NewLine);</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>I hope that helps!</P> Thu, 07 Mar 2024 23:20:36 GMT RoryMcPherson 2024-03-07T23:20:36Z https://community.esri.com/t5/arcgis-online-questions/how-to-return-distinct-values-from-a-related-table/m-p/1391769#M57888 <P>Hello!&nbsp;</P><P>I have an Arcade expression which returns values from a related table within a popup. It works great except that it returns every value in the 1:M relationship, so there are many duplicates. Is it possible to modify my expression to only return the distinct values from the related records? Any help is appreciated.&nbsp;</P><P>My expression&nbsp;</P><LI-CODE lang="c">var fs = FeatureSetByName($map, "RELATED TABLE" , ['*'], false); var result = ""; var cnt = Count(fs); if (cnt &gt; 0) { // start loop through related records for (var f in fs) { // for each f (=feature) in related features, add attendee to the result result += TextFormatting.NewLine + f.FIELDRETURNED; } } else { // overwrite result with text to indicate that there are no attendees result = ""; } return result;</LI-CODE><P>Thanks!</P> Wed, 06 Mar 2024 13:00:24 GMT https://community.esri.com/t5/arcgis-online-questions/how-to-return-distinct-values-from-a-related-table/m-p/1391769#M57888 DaveK 2024-03-06T13:00:24Z https://community.esri.com/t5/arcgis-online-questions/how-to-return-distinct-values-from-a-related-table/m-p/1392933#M57972 <P>There is a <A href="https://developers.arcgis.com/arcade/function-reference/array_functions/#distinct" target="_self">Distinct</A> function available in Arcade you can use to do this, however, you need to have an&nbsp;<A href="https://developers.arcgis.com/arcade/function-reference/array_functions/#array" target="_self">Array</A>&nbsp;to return the unique values from. If you populate your result values into an array, you can use the Distinct function to return the unique results.</P><P>If you are happy with returning an array, then you can use the script below:</P><P>&nbsp;</P><LI-CODE lang="javascript">var fs = FeatureSetByName($map, "returnDistinct" , ['*'], false); var fsArray = Array(1); var fsCount = Count(fs); // check for features if (fsCount &gt; 0) { for (var f in fs) { // for each feature, add to the array Push(fsArray, f.name) } } else { return "No records available"; } // return distinct values return Distinct(fsArray);</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>If you prefer to return a text string instead, I modified the script slightly so that you can do that too. Just noting however that the first line returned is a "null" value creating an empty first line, which is why I've also added an Erase function to remove the 0 index.</P><P>&nbsp;</P><P>&nbsp;</P><LI-CODE lang="javascript">var fs = FeatureSetByName($map, "returnDistinct" , ['*'], false); var fsArray = Array(1); var fsCount = Count(fs); // check for features if (fsCount &gt; 0) { for (var f in fs) { // for each feature, add to the array Push(fsArray, f.name) } } else { return "No records available"; } // return distinct values // return Distinct(fsArray); // return distinct values text Erase(fsArray, 0); // remove 0-index "null" field return Concatenate(Distinct(fsArray), TextFormatting.NewLine);</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>I hope that helps!</P> Thu, 07 Mar 2024 23:20:36 GMT https://community.esri.com/t5/arcgis-online-questions/how-to-return-distinct-values-from-a-related-table/m-p/1392933#M57972 RoryMcPherson 2024-03-07T23:20:36Z