topic Re: How to calculate a field based on attributes from two other fields? in ArcGIS Pro Questions

How to calculate a field based on attributes from two other fields?

hannahisreeding — Mon, 26 Feb 2024 15:36:57 GMT

I'm attempting to use Arcade to populate the length from a different field to a new field but only if that length corresponds to a certain label I have attributed in another different field.

The expression I have above does not work 😞

Re: How to calculate a field based on attributes from two other fields?

marksm_macomb — Mon, 26 Feb 2024 17:03:58 GMT

Here is an article that will help you understand If statements a little better. Your current statement is just formatted incorrectly. It should read something like this:

If($feature.Clabel == "BFO24W"){ return $feature.ClengthFt }

Re: How to calculate a field based on attributes from two other fields?

hannahisreeding — Mon, 26 Feb 2024 17:34:09 GMT

THANK YOU SO MUCH!! That worked perfectly! and thank you so much for the helpful link, hopefully someday I'll understand these expressions 😅

Re: How to calculate a field based on attributes from two other fields?

hannahisreeding — Mon, 26 Feb 2024 18:25:16 GMT

Is there any way I could get the expression to recognize all attributes that begin with BFO24W, even if they have different information populated after that?

Re: How to calculate a field based on attributes from two other fields?

marksm_macomb — Mon, 26 Feb 2024 20:58:06 GMT

I would take a look at the discussion in this thread.

The solution from that thread will allow you to find "BFO24W" anywhere in the string, and another user suggests an idea that may limit results to where "BFO24W" is only located at the beginning of the string.