Arcade expression to display multiple field values based on corresponding field value

kshahmmp

Hi,

I need to display fields and its values in popup panel based on one of its corresponding field values. I tried using if/else statement but doesn't return the values that I want. I found esri support help resources (https://support.esri.com/en/technical-article/000024112) but couldn't able to resolve. What is was particularly looking is 

if ($FieldName4 == 1) {

    return FieldName1.Value, FieldName2.Value, FieldName3.Value

}

if ($FieldName4 == 2) {

    return FieldName1.Value, FieldName2.Value, FieldName3.Value

}

For instance in the above esri resource table; I need to display all the values for fields i.e. 'Student_ID', 'Grade1', 'Grade2' that are related to Field value 'Excellent' from 'Results' Field.

Both expression has to be displayed in same popup though. 

Not sure if there is any better way to do other than if/else statement. I would greatly appreciate for any help or resources in this regard.

Thanks,

kshah

 

XanderBakker

Hi @kshahmmp ,

A couple of pointers here. When you want to access to value in a field called "FieldName1", you can use two ways to do this:

$feature.FieldName1
$feature["FieldName1"]

 

The second option is preferred when you have a field name containing an underscore:

$feature["Field_Name1"]

 

The code you posted raised a couple of questions:

• Do you want to return a text containing the values of 3 fields separated by a comma?
• Do you want to return the same 3 fields when FieldName4 is either 1 and 2 (or are there other fields to return?)

Based on a number of assumptions see the example below. In this case, when FieldName4 is 1 a text with FieldNames 1, 2, and 3 will be returned and when FieldName4 is 2, a text with FieldNames 5, 6, and 7 will be returned. It uses the Concatenate function and provides an array (list) of the field values and the text to separate the field values.

if ($feature.FieldName4 == 1) {
    return Concatenate([$feature.FieldName1, $feature.FieldName2, $feature.FieldName3], ", ");
} else if ($feature.FieldName4 == 2) {
    return Concatenate([$feature.FieldName5, $feature.FieldName6, $feature.FieldName7], ", ");
}