topic Re: Domain Field Returning Non-Domain Values in ArcGIS Pro Questions

Domain Field Returning Non-Domain Values

minhomo28 — Wed, 19 Apr 2023 22:57:37 GMT

Hi,

I currently have a field with domain applied to it. I copied over bunch of values to the domain field using field calculator. My expectation was that the domain will exclude all the non - domain values ( Null) and keep only the values that are in the domain list. Apparently, it is not happening. Non - domain values are still showing in the domain field. Does anyone know how this could be fixed?

Thanks.

Re: Domain Field Returning Non-Domain Values

JoshuaSharp-Heward — Thu, 20 Apr 2023 06:59:53 GMT

Hi,

There's a button at the bottom of the "Field Calculator" dialogue box called "Enforce Domains" - your problems should be solved by ensuring it's checked before running your calculation https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/calculate-field.htm

Re: Domain Field Returning Non-Domain Values

minhomo28 — Thu, 20 Apr 2023 17:33:23 GMT

Hi,

Thanks for the reply.

Yes, I have been trying to used this function and it has been giving me an error message and doesn't move any values over to the field.

Re: Domain Field Returning Non-Domain Values

JoshuaSharp-Heward — Thu, 20 Apr 2023 20:52:58 GMT

Hi,

I've tested it on my end and it seems to work - have you set "allow null values" to no on your field with the domain? If so then it would be trying to set non-domain values to Null and then stop working as it's not allowed.

If not, can you post a screenshot of the error message?

Re: Domain Field Returning Non-Domain Values

minhomo28 — Fri, 21 Apr 2023 16:24:38 GMT

Hi,

My domain field do allow Null values. This would be the example of the error message I have been getting.

Re: Domain Field Returning Non-Domain Values

JoshuaSharp-Heward — Thu, 20 Apr 2023 21:27:41 GMT

Oh I thought the calculate field was failing, not completing with warnings. And it's not working for any of the records, even ones that look like they should work? Does your input data match the codes or the descriptions in the domain?

Re: Domain Field Returning Non-Domain Values

minhomo28 — Thu, 20 Apr 2023 21:43:24 GMT

Yes, it is giving a warning and not moving any data over to the domain field. I am pretty sure input data match with code descriptions.

Re: Domain Field Returning Non-Domain Values

minhomo28 — Thu, 20 Apr 2023 21:48:28 GMT

Could this be some sort of setting issue in my database ?

Re: Domain Field Returning Non-Domain Values

JoshuaSharp-Heward — Thu, 20 Apr 2023 21:48:38 GMT

Can you post a picture of the domain as well as some of the input data that should match the domain?

Re: Domain Field Returning Non-Domain Values

minhomo28 — Thu, 20 Apr 2023 21:57:16 GMT

Those input data should be moving over to domain field since they match the domain list, I believe.

Re: Domain Field Returning Non-Domain Values

JoshuaSharp-Heward — Thu, 20 Apr 2023 22:07:50 GMT

Hi,

It needs to match the 'code' not the 'description', as the code is what's stored in the database and the description is what it's shown as. That'll be why it's failing for you.

Re: Domain Field Returning Non-Domain Values

Robert_LeClair — Thu, 20 Apr 2023 22:08:40 GMT

In reviewing the screen grab of the error message thrown in the tool, I found this link here regarding the description of the error and the solution. Are you doing any field mapping at all?

Re: Domain Field Returning Non-Domain Values

minhomo28 — Thu, 20 Apr 2023 22:36:48 GMT

I think that will make the drop down of code values , not description values. For example, the drop down list of domain field will give a list of Code 1 , Code2, Code3 .... instead of giving PRV1, PRV2, PRV3.

Or am I misunderstanding how domain works?

Re: Domain Field Returning Non-Domain Values

minhomo28 — Thu, 20 Apr 2023 22:41:04 GMT

I am just using Field Calculator to move data to domain field.

Re: Domain Field Returning Non-Domain Values

JoshuaSharp-Heward — Thu, 20 Apr 2023 22:55:31 GMT

The code is what's stored in the db and the description is what's shown. If you try to enter the description into the database it won't recognise it as a valid option. When digitising information in pro it will present you the description in the drop down but store the code behind the scenes. You can see that in action by switching off "show domain and subtype descriptions" check box in the attribute table.

So to successfully populate that data over you will have to find a way of converting those "description" values to their respective codes, I'd personally use a dictionary as a lookup table.

Re: Domain Field Returning Non-Domain Values

minhomo28 — Thu, 20 Apr 2023 23:17:56 GMT

Ah you are absolutely right. Thank you so much for the help!

Re: Domain Field Returning Non-Domain Values

JoshuaSharp-Heward — Fri, 21 Apr 2023 05:18:11 GMT

No worries 🙂 glad I could help out! Do you want to mark this as solved so people know we've got a resolution?

Re: Domain Field Returning Non-Domain Values

minhomo28 — Fri, 21 Apr 2023 16:15:00 GMT

Will do . Thanks again!