I am trying to create an expression that will return all coded values from two fields (STATUS and Funding_Source) so that I can symbolize based on the results.
For example. if I have Status's coded values as:
A, B, C
and Funding_Source as:
X, Y, Z
I want symbology for:
A-X, A-Y, A-Z, B-X, B-Y, B-Z, C-X, C-Y, C-Z
If I use concatenate($feature.STATUS,'-',$feature.Funding_Source)
I only get values for populated fields not all coded values)
I tried building an arcade expression:
var STarray = Array(0)
var SD = Domain($feature, 'STATUS').codedValues
var FD = Domain($feature, 'Funding_Source').codedValues
for (var i = 0; i < Count(SD); i++) {
for (var a = 0; a < Count(FD); a++) {
Insert(STarray, 0, Concatenate(SD[i].code,'-',FD[a].code))
}
}
STarray
It returns an array of exactly what I want, but it makes 1 symbol with a legend value of the entire array output.
Is there a way to symbolize on two fields and get all coded values?
Thanks much,
JB