Arcade data expression: match IDs from two feature sets (join fields, 1:1)

Merlin — Wed, 22 Sep 2021 12:02:09 GMT

Hi there,

this time I have a question that might be a bit tricky: how can you loop through a featureSet (fs1) and check each time if the current ID is found in another featureSet (fs2)?

I basically try to achive a join field operation from ArcGIS Pro.

To illustrate:

I want to loop through fs1 containing IDs:

and for each ID in the loop, I would like to see if there is a matching ID in fs2.

My initial idea was to have a first for loop to move through the rows of fs1 and then have a second for loop nested within the first, which could pick up the current ID value and loop through fs2 to find a match. But I didnt manage to make nested for loops pointing at different featureSets working.

Any ideas?

Thanks in advance,

Merlin

Re: Arcade data expression: match IDs from two feature sets (join fields, 1:1)

JohannesLindner — Wed, 22 Sep 2021 13:20:39 GMT

var fs1 = FeatureSetByName(...) var fs2 = FeatureSetByName(...) for(var row1 in fs1) { var id1 = row1.FFGId var filtered_fs2 = Filter(fs2, "FFGId = @id1") for(var row2 in filtered_fs2) { // do stuff } }

topic Re: Arcade data expression: match IDs from two feature sets (join fields, 1:1) in ArcGIS Dashboards Questions

Arcade data expression: match IDs from two feature sets (join fields, 1:1)

Re: Arcade data expression: match IDs from two feature sets (join fields, 1:1)