topic Re: The Arcade Count() is giving an odd error in ArcGIS Pro Questions

The Arcade Count() is giving an odd error

RyanBohan — Fri, 22 Apr 2022 16:02:06 GMT

I am trying to use Count() for a simple count of a string in a text field in a feature table in Pro.

It should be as simple as Count(fieldname)

Error

Works on another field

Both are text fields

jcarlson — Fri, 22 Apr 2022 16:06:52 GMT

Hmmm. Does it behave any differently if you use bracket notation? As in, $feature['Address_From2']?

RyanBohan — Fri, 22 Apr 2022 16:25:44 GMT

Thanks for the suggestion, I am still getting the error.

It appears if the first row is <null> that is when the error happens. I am using ArcPro 2.9.2

I am pulling in a csv, and exporting the table to gdb

Current work around is adding in a dummy row of values.

jcarlson — Fri, 22 Apr 2022 16:40:16 GMT

Oh, right! It uses that first row to validate the script. Okay, try an expression like this:

var addr = $feature['Address_From2'] Iif(IsEmpty(addr), 0, Count(addr))

By checking if the value is null first, and explicitly giving nulls an output value, this should pass validation.

RyanBohan — Fri, 22 Apr 2022 19:57:30 GMT

Thank you @jcarlson! That does it.