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; } } }

arcade in attributetable

Gisbert61

I try to clean up an attributetable using calculate field and arcade, some records have their creator in a column 'creator_1' instead of creator so I wrote:

IIf(IsEmpty($feature.Creator),$feature.Creator_1,$feature.Creator)

But all I get is: Invalid expression. error on line 1. Open parenthesis expected

I've looked at the arcade reference and other sources I could think of but I can't see what i'm doing wrong. ArcGIS PRO 2.5.1

your help would be appreciated!

regards,

Bert

Find more posts tagged with

Accepted answers

Gisbert61

Hello Dan and Xander,

Sorry it took a while before i could get back on this, thanks for both your reactions.

I found this to do what I wanted:

if creator is empty copy value from creator_1 else take current value.

Unclear why the else is needed but if i omit that the field gets emptied (null)

Is there a arcade for dummies somewhere? I can't find much help from the reference

Bert

All comments

danretired

Bert Kraan‌

Don't see one for 'dummies' but this is the documentation that I refer to

Getting Started | ArcGIS for Developers

Arcade Function Reference | ArcGIS for Developers

Gisbert61

Hello Dan and Xander,

Sorry it took a while before i could get back on this, thanks for both your reactions.

I found this to do what I wanted:

if creator is empty copy value from creator_1 else take current value.

Unclear why the else is needed but if i omit that the field gets emptied (null)

Is there a arcade for dummies somewhere? I can't find much help from the reference

Bert

XanderBakker

Hi Bert Kraan ,

In addition to what danretired already mentioned, it is important to select the fields you use from the list above, to be sure that you are using the correct field names. In some implementations of Arcade a field with an underscore need to be addressed like $feature["Creator_1"]. Just so you know. But I suppose following the advise of Dan should solve your problem.

danretired

Creator_1 isn't in your list Creator1 is and it looks like you are trying to calculate into Creator and use its value at the same time.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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