Create a list which only shows unique values, no duplicates.

kstone_ntia

I am looking to create a list only showing the unique values from a layer. The example is below. 

Original Table Example

I want the list to only read Applicant 1 and Applicant 2. Not list them multiple times which is how the list currently works. My goal is to select applicant 1 and see various charts associated with that applicant. 

I appreciate any guidance you have. 

Kelly

 

 

JohnEvans6

Happy to thanks for looking. Should be pretty straightforward:

var fieldName = "IWL_NAME";
var features = FeatureSetByPortalItem(Portal("https://faasysops.maps.arcgis.com/"), '8abc49df0f9247b9abd7b62eaa37952d', 0)
var uniqueIds = GroupBy(features, [fieldName], { name: "f_objID", expression: "OBJECTID", statistic: "FIRST" });

var unique_list = [];

for (var id in uniqueIds) {Push(unique_list, id.f_objID)}

var sql = "OBJECTID IN (" + Concatenate(unique_list, ", ") + ")";
return Filter(features, sql);

As above the feature set is filtered down to 2 records, which I want to display in the table behind in the screenshot. I figured the table would just load the 2 records in the output, but it loads them all.