topic Re: Adding a comma between multiple values in ArcGIS Pro Questions

Adding a comma between multiple values

IanLadd_Tourmaline — Thu, 12 Sep 2024 15:46:17 GMT

Hello,

I have an Arcade script that inserts the name of a boundary polygon if it intersects with the feature. How do I show a comma between only the ones where it intersects multiple polygons? My current code just adds a "," to everyone regardless if it's only one value.

var land = FeatureSetByName($datastore,"Boundary_Aug2024",["Name"], true) var intersectLayer = Intersects(land, Geometry($feature)) var result = ''; if (Count(intersectLayer) > 0) { for (var layer in intersectLayer) { result += layer.Name+(", ") ; } } else { result = "Null" } return result

Re: Adding a comma between multiple values

clt_cabq — Thu, 12 Sep 2024 16:27:58 GMT

Looks like you can nest if/else statements if you scroll down in the linked documentation to the section titled "Nested if/else". Another option it shows there is the IIF statement that might work for you as well

if else and other control logic

Re: Adding a comma between multiple values

IanLadd_Tourmaline — Thu, 12 Sep 2024 17:07:31 GMT

So I would create an nested if statement where if it's greater than one, then it inserts a comma between the values? How do I specify between them and not end up with another , after the end?

Re: Adding a comma between multiple values

KenBuja — Thu, 12 Sep 2024 17:26:31 GMT

You can add the items to an array and use the Concatenate function. This wouldn't add an extra comma if there is only one result.

var land = FeatureSetByName($datastore, "Boundary_Aug2024", ["Name"], true); var intersectLayer = Intersects(land, Geometry($feature)); var result = []; if (Count(intersectLayer) == 0) return "Null"; for (var layer in intersectLayer) { Push(result, layer.Name); } return Concatenate(result, ", ");

Re: Adding a comma between multiple values

clt_cabq — Thu, 12 Sep 2024 17:29:25 GMT

of course this is the best answer! Thanks for showing this approach @KenBuja

Re: Adding a comma between multiple values

IanLadd_Tourmaline — Thu, 12 Sep 2024 18:11:56 GMT

Amazing! Thank you so much @KenBuja