topic Re: Calculate Field using IF and FIND arcade statement in ArcGIS Online Questions

Calculate Field using IF and FIND arcade statement

JoshLay1 — Mon, 30 Sep 2024 14:02:30 GMT

I have two fields both are text and I am using the field calculator to calculate the empty field. The populated field is name "groupNames" which contains values such as below. The second field "agency" has no values and is where the calculated values are going. I am trying to use arcade to find any values in the "GroupNames" field that contain the agency acronym such as "DDOT", then calculate the empty field with "DDOT" otherwise populate with "Undefined". I have been using the Arcade statements below but cannot get them to work. Anyone have suggestions?

IIF(Find('DDOT', $feature.groupNames)== 0, "DDOT", "Undefined")‍‍
IIF(Find('DPW', $feature.groupNames)== 0, "DPW", "Undefined")‍‍
IIF(Find('CFSA', $feature.groupNames)== 0, "CFSA", "Undefined")‍‍

Thanks

Josh

Re: Calculate Field using IF and FIND arcade statement

CodyPatterson — Mon, 30 Sep 2024 14:01:11 GMT

Hey @JoshLay1

Looks like you almost have it, -1 is the way to find if a result is not present, you may need to use a negation, try this out:

IIf(Find('DDOT', $feature.groupNames) != -1, "DDOT", "Undefined") IIf(Find('DPW', $feature.groupNames) != -1, "DPW", "Undefined") IIf(Find('CFSA', $feature.groupNames) != -1, "CFSA", "Undefined")

https://developers.arcgis.com/arcade/function-reference/text_functions/#find

Cody

Re: Calculate Field using IF and FIND arcade statement

JoshLay1 — Mon, 30 Sep 2024 14:20:38 GMT

Thanks for the quick reply Cody.

I tried using your expression from line 1 as a test and received the error message below.

Re: Calculate Field using IF and FIND arcade statement

KenBuja — Mon, 30 Sep 2024 14:31:52 GMT

If your goal is to get the agency name for each feature rather than finding the ones that are "DDOT", then you should use this.

When(Find('DDOT', $feature.groupNames) != -1, 'DDOT', Find('DPW', $feature.groupNames) != -1, 'DPW', Find("CFSA", $feature.groupNames) != -1, 'CFSA', // add all the other agency names you're looking for 'undefined')

Re: Calculate Field using IF and FIND arcade statement

JoshLay1 — Mon, 30 Sep 2024 14:54:09 GMT

Thanks Ken and Cody that worked! ESRI Community is awesome!

Re: Calculate Field using IF and FIND arcade statement

KenBuja — Mon, 30 Sep 2024 14:54:13 GMT

If you have a long list of agencies to check, this might be a better way. You can modify the array of agencies easier than making a long When function

var agencies = ["DDOT", "PEMA", "CFSA"]; var output = "undefined"; for (var j in agencies) { if (Find(agencies[j], $feature.groupNames) != -1) output = agencies[j]; } return output