Custom conditional symbology based on multiple categorical columns

[Ed_]

So I have to create like two maps based on two separate sets of conditions based on the values in columns `park` and `forest`

Case 1: When both `park` and `forest` values are present color `light pink` (Also can I directly put the color name or HEX code here?). When either one of the values are present then color `light blue`

Arcade code goes here

Case2: When both values are NULL then color `light blue`.   When either one of the values are present then color `light pink`

Arcade code goes here

I did try the return function with when and logical operators but kept on getting errors. I am still new to custom symbology with Arcade so guidance will be appreciated.

Sample Data:

Park   Forest
park   forest
<Null> <Null>
park   forest
park   forest
<Null> forest
park   forest
<Null> forest
<Null> <Null>
<Null> forest
<Null> forest
<Null> <Null>
park   forest

[Ed_]

@jcarlson can you please help when you have the time? cheers

[jcarlson · Accepted solution]

Just a reminder that what the expression returns will not be the exact color, but rather a string that defines a category. You can put the hex code in if you want, but for all the difference it will make to the actual symbol you may as well put "A" and "B".

var p = !IsEmpty($feature.park)
var f = !IsEmpty($feature.forest)

// case 1

return When(
  p && f, 'light pink', // both present
  p || f, 'light blue', // one present
  ''
)

// case 2

return When(
  !p && !f, 'light blue', // both NULL
  p || f, 'light pink', // either present
  ''
)

[Ed_]

Thank you so much for the quick response 🙂.

Happy Holidays!