topic Using Field Calculator with iif statement, I get "Cannot assign to const value". Why, please? in Data Management Questions

Using Field Calculator with iif statement, I get "Cannot assign to const value". Why, please?

NancyDorsey — Tue, 28 Jul 2020 16:00:15 GMT

Arcade statement:

IIf($feature.HOLE = "HORIZONTAL",1,2)

Error: Arcade cannot assign to constant value. Why? I am trying to set up weighting criteria. I tried setting the field to both long and short numbers, but still get errors. All help appreciated. thank you.

Re: Using Field Calculator with iif statement, I get "Cannot assign to const value". Why, please?

JoshuaBixby — Tue, 28 Jul 2020 16:13:42 GMT

Try:

IIf($feature.HOLE == "HORIZONTAL",1,2)‍

Re: Using Field Calculator with iif statement, I get "Cannot assign to const value". Why, please?

NancyDorsey — Tue, 28 Jul 2020 16:29:14 GMT

That worked, thanks! Too bad ESRI has it wrong or incomplete in their documentation! Thank you again! CORRECTION: ESRI does have it correct, I was not using the Arcade syntax but thinking of the Desktop simple and obvious language no longer used. Sigh. New tricks are hard.

Re: Using Field Calculator with iif statement, I get "Cannot assign to const value". Why, please?

JoshuaBixby — Tue, 28 Jul 2020 17:01:14 GMT

Please close out this question if everything is working for you.

Re: Using Field Calculator with iif statement, I get "Cannot assign to const value". Why, please?

NancyDorsey — Tue, 28 Jul 2020 17:07:29 GMT

I don't know how...though it looks like I have.

Re: Using Field Calculator with iif statement, I get "Cannot assign to const value". Why, please?

KenBuja — Tue, 28 Jul 2020 18:00:09 GMT

Where is that incorrect in the documentation?