nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

The Arcade Count() is giving an odd error

RyanBohan

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

タグ付けされた投稿をもっと見る

Desktop

Accepted answers

jcarlson

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.

All comments

RyanBohan

Thank you @jcarlson! That does it.

jcarlson

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

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.

sample.csv

GeoMentor_Newsletter_March2016.pdf

jcarlson

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

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.