Latest Contributions by LukeHaskett

Hi, Arcade is still very new to me so forgive me if this seems like a basic error. I'm trying to use arcade to loop through the rows of a feature class and return the number of non-null fields for each row. I'm using the following code but it just produces the number of items in the array (3) for each row: var array = [$feature.Welcoming,$feature.Access,$feature.Community]; var total = 0;    for(var k in array){       Iif(isempty(k),total+=0,total+=1); } return total Would really appreciate some pointers, I can't seem to crack this. So for instance, in a row where two of the variables in the 'array' were null I would expect/need it to return '1' (the number of non-nulls)... equally if one of the variables were null I would need it to return '2'. Thanks! ... View more

Hi! I'm trying to run a field calculator statement to fill an integer field based on a preceding text field - so depending on what the text is, a certain number will be assigned to it. However, the field calculator statement I'm using only seems to work if the text has no spaces in it... any help with this would be greatly appreciated! The expression is: Reclass(!Typology!) And the code black is: def Reclass(Typology):    if Typology is "Allotments":       return 0.30    elif Typology is "Amenity Green Space":       return 0.40    elif Typology is "Park and Recreation Ground":       return 1.65 etc. However, in the example above, only allotments will be assigned the requested number. If I removed the spaces from the other text, the calculation works but this isn't acceptable for what I need. Many thanks in advance. Luke ... View more

Hello, I'm stumped by a problem that I think should have a fairly straightforward answer... I have a few hundred features with a number of attributes, all numerical. Some features have all attributes filled in, but some have a handful of null values. Is there any way of calculating the mean value for each feature that takes into account these null values? For instance, it calculates how many attributes are not null for each feature and uses that to generate the mean? Would really appreciate any help on this! Thanks ... View more

Hello, I'm trying to build a model that can take any feature class loaded in and then have the field names available as a user-selected variable which will then power a bunch of geoprocessing tools. How do I set this up so that I can choose the dataset and then the appropriate field name before pressing run on the model? Thanks! Luke ... View more