topic Return single text values in list from comma separated field in ArcGIS Dashboards Questions

Return single text values in list from comma separated field

dwold — Wed, 05 Jun 2024 14:36:37 GMT

I am trying to display text that has multiple responses and populate them in a list individually. In the example below my goal is to have something shown below but single responses in each target, not all 5 listed for every one

Goal is to get Targets to read:

Target: Relocation_Assistance

Target: Relocation_Assistance_for_People_with_Access_and_Functional_Needs

Target: Community_Sheltering

Target: Community_Sheltering_for_People_with_Access_and_Functional_Needs

Target: Community_Sheltering_Animals

There may be only on "target" so if that is the case, I'd like the list to retunr that single text sting. Right now my list is doing this:

Here's what I currently have in my Advanced Formatting section:

This isn't correct but would I do something along the lines of:

var target_one = ([$datapoint.target] , 0)

var target_two = ([$datapoint.target] , 1)

var target_three = ([$datapoint.target] , 2)

@KenBuja I saw you commented on another post about using the OrderBy but I'm not sure if that would work in this situation?

Re: Return single text values in list from comma separated field

KenBuja — Wed, 05 Jun 2024 14:40:16 GMT

You can use the Split function to separate out the comma-separated values into an array and loop through that array to get the list of targets. This will also work if there is just one target.

Re: Return single text values in list from comma separated field

dwold — Wed, 05 Jun 2024 15:11:45 GMT

@KenBuja thanks for the suggestion/investigation this! I am on the right track, but it lists each target instead of the single one for each "section". I believe it is because the split values aren't empty?

Current list:

my goal is to have something like this:

Any suggestions on how to get that look?

Re: Return single text values in list from comma separated field

KenBuja — Wed, 05 Jun 2024 16:16:15 GMT

If I understand how your fields are set up, give this a try:

**Edited to fix an error (i.e. "$datapoint[tg]" instead of "$datapoint.tg")**

Re: Return single text values in list from comma separated field

dwold — Wed, 05 Jun 2024 18:01:56 GMT

@KenBuja that worked! as always very much appreciative for your time and help!

Re: Return single text values in list from comma separated field

dwold — Thu, 06 Jun 2024 13:21:17 GMT

@KenBuja I added some more fields to the code and got it (mostly) working. After adding those additional fields, the list doesn't return the second Unemployment values (those are the fields I added). Do you see anything in the code that is preventing the list from displaying the second Unemployment values?

Would splitting out Unemployment from the rest be a possible solution? I am new to arcade and not good with if statements but something like this:

in between lines 4 & 5: if cap_target_text != 'Short Term Unemployed and Underemployed' , 'Long Term Unemployed and Underemployed'

in between lines 29 & 30: if cap_target_text == 'Short Term Unemployed and Underemployed' , 'Long Term Unemployed and Underemployed'

I've attached the data table I am using

Re: Return single text values in list from comma separated field

KenBuja — Thu, 06 Jun 2024 15:48:25 GMT

A little explanation of what my code is doing. It makes the array of targets and loops through them. The variable i is a number representing the position of the element in the array, so it will be 0 for the first loop, 1 for the second loop, and so on. That number gets tacked on the end of the field name if the number isn't equal to zero with this IIf function

var tg = iif(i > 0, `target_goal_${i}`, 'target_goal')

Unfortunately, you're adding more complexity to this. Looking at the data, the employment fields are only going to be added for the targets "Short_Term_Unemployed_and_Underemployed" and "Long_Term_Unemployed_and_Underemployed. Also, the "Situational_Briefings" target uses a different naming convention. So this code searches for those cases and gets the fields differently.

Re: Return single text values in list from comma separated field

dwold — Thu, 06 Jun 2024 17:40:25 GMT

@KenBuja Awesome, Thank you!!!!