Domain Field Returning Non-Domain Values

minhomo28 · ‎04-19-2023

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.

JoshuaSharp-Heward · ‎04-20-2023

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.

View solution in original post

JoshuaSharp-Heward · ‎04-19-2023

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

minhomo28 · ‎04-20-2023

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.

JoshuaSharp-Heward · ‎04-20-2023

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?

minhomo28 · ‎04-20-2023

Hi,

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

JoshuaSharp-Heward · ‎04-20-2023

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?

minhomo28 · ‎04-20-2023

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.

minhomo28 · ‎04-20-2023

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

JoshuaSharp-Heward · ‎04-20-2023

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

minhomo28 · ‎04-20-2023

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