nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Calculate Field using IF and FIND arcade statement

JoshLay1

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

Finde mehr Beiträge mit dem Tag

Data and services

Arcade

Accepted answers

kenbuja

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')

All comments

kenbuja

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

JoshLay1

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

kenbuja

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')

JoshLay1

Thanks for the quick reply Cody.

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

CodyPatterson

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

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Alle Communities
Neueste Beiträge
Gefolgter Inhalt
Community-Hilfe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.