Having syntax issues with 'When' function for recalculating ages

slach — Sun, 14 Aug 2022 19:06:05 GMT

Hi there,
I have what I thought to be a simple arcade expression that I'm trying to use for a dashboard indicator. Currently I'm working with a table where ages are a string variable and some records have 'NN" or 'BB' to refer to their stage in infancy. I'm looking to recalculate those records to be 0 and then to convert all the ages to integers so I can find the average.
I've been playing with this script all day and I think I'm running into syntax issues with recalling my feature service. Either that or I'm just not understanding the When function. I would really appreciate any suggestions or help!

var port = "https://--------------.arcgis.com" var itemID = "---------------------------------" var layerID = 3 var fields = ['AGE'] var geo = False // Set up the FeatureSet with which to call: var FS = FeatureSetByPortalItem(Portal(port), itemID, layerID, fields, geo) // return the set of features to use within indicator: When($FS.AGE ='BB', '0', $FS.AGE = 'NN', '0', defaultValue); var newagesdictionary = { 'fields': [ { 'name': 'age_recalc', 'type': 'esriFieldTypeInteger'} ], 'geometryType':'', 'features': [{'attributes': {'newage': Number($FS.AGE)} }]} var recalcagedict = FeatureSet(Text(newagesdictionary)); return recalcagedict

I keep getting 'Invalid Parameter as an error message but I'm not sure where it's really referring to.

Thank you so much!

Re: Having syntax issues with 'When' function for recalculating ages

JohannesLindner — Mon, 15 Aug 2022 06:32:57 GMT

You're misunderstanding the When function.

When() doesn't work on feature sets. It takes multiple booleans and objects and returns the object following the first true boolean.

var x = 1 // this will return 25 return When(x == 0, "a", x == 1, 25, x == 2, "z", "default")

Other things:

the dollar sign denotes global variables like $feature, $map, or $layer. You can't just put it in front of custom variables.
In most programming languages, "=" is assignment ("var x = 3"). To test for equal, use "==" ("x == 3" -> true)
FS is a FeatureSet, a collection of Seatures. You can't call a field on a FeatureSet, only on the separate Features.
in your dictionary, you have a different name for the field in the fields declaration and the feature attributes.

To solve your problem, create an empty dictionary, then loop through the FeatureSet and Push the corrected values into the feature array:

var port = "https://--------------.arcgis.com" var itemID = "---------------------------------" var layerID = 3 var fields = ['AGE'] var geo = False // Set up the FeatureSet with which to call: var FS = FeatureSetByPortalItem(Portal(port), itemID, layerID, fields, geo) // return the set of features to use within indicator: var newagesdictionary = { 'fields': [ { 'name': 'age_recalc', 'type': 'esriFieldTypeInteger'} ], 'geometryType':'', 'features':[] } for(var f in FS) { var new_age = When(f.AGE == 'BB', '0', f.AGE == 'NN', '0', f.AGE) var new_feature = {'attributes': {'age_recalc': Number(new_age)}} Push(newagesdictionary.features, new_feature) } var recalcagedict = FeatureSet(Text(newagesdictionary)); return recalcagedict

topic Re: Having syntax issues with 'When' function for recalculating ages in ArcGIS Online Questions

Having syntax issues with 'When' function for recalculating ages

Re: Having syntax issues with 'When' function for recalculating ages