Latest Contributions by AndrewIngall1

Hello I have created a Arcade expression to look if a point intersects a polygon and return the name of the polygon within the pop up if if finds anything, if not it will return private land. The code is below. var fs = FeatureSetByName($map,"United Kingdom LSOA Boundaries 2019") var int = First(Intersects($feature, fs)) If (int == Null) { return "Private Land" } else { return Proper(int.NAME, 'everyword') }   The question is how can i check other polygon layers at the same time to find the name of the polygon?  I am thinking along the lines of IF ELSE THEN So test the first polygon, if the point is within that return the name, if not test the second polygon layer and if the point is intersecting with that, then return the name.  If there is no intersection then return Private Land...   Thanks for any help.   ... View more

I am trying to use the field calculator to concatenate various fields into one new field.  The ArcGIS Arcade Guide gives the following example Concatenate(['red', 'blue', 'green'], '/') which gives red/blue/green.  This works fine when all of the fields contain a value, but how can i concatenate only the fields that are not null I am trying to concatenate address details , so for example  field1 = building name field2 = building number field3 = road name field4 = area field5 = town in my example the building name or area could be null, so i end up with:- ,12,A Road,,Town - so i need to remove the additional field separators ',' Thanks for any help ... View more