How do I calculate values for a field by concatenating two fields and having each combination have its independent incrementing number

Question

I would like to be able to calculate a text field for use as a unique ID based on two other fields for a feature. In my current case, I am creating a Light Post map and want the ID to be based on the field that says what neighborhood it is in, and the field that says what type of light post it is.

So it would look something like this:

Neighborhood = CC, CL, CR, EV, MA, or GQ

Post Type = G, M, O, or T

So the result should look like this

CC-G-1

CC-G-2

CC-M-1

CC-G-3

CL-M-1

CL-G-1

CL-M-2

And so on

Any help would be appreciated

jcarlson · Answer

Agh, Arcade doesn't always play nice with Pro the way it does in other contexts. You need to pull in the layer somehow. Check the "helper functions" list in the expression builder, there might be something in there. If the layers are in the same data source, you can try using $datastore instead of $layer. Or you may have to use FeatureSetByPortalItem.

AydanScottDSDP · Answer

@jcarlson I have been having issues with line 3 (or 4 on your post) so far, I'm probably missing something obvious but it says "Object not found $layer"

Any idea why this would be?

If not, I'll post another question.

Screenshot 2023-07-19 084522.png

AydanScottDSDP · Answer

@Robert_LeClair  - That's about as far as I've been able to get as well. I have also been playing around with various ideas. I'm sure there is a way, but I have yet to find it.