Defining coded value domains

bsklaohfl

Hi, 

I have a coded value domain for a field called asset owner, from -1 to -7. Which function would I use to define each value with a string. Example, -1 = Private, -2 = Other, etc etc.

Thank you.

Ian_Muehlenhaus

Hi bsklaohfl,

I believe you would:

* Show Table
* Add Field
* Then type:

IF(codedFieldName=-1,”Private”,IF(codedFieldName=-2,”Other”,IF(codedFieldName=-3,”Other2”,IF(codedFieldName=-4,”Other3”,IF(codedFieldName=-5,”Other4”,IF(codedFieldName=-5, “Other5”, IF(codedFieldName=-6,”Other6”, IF(codedFieldName=-7,”LastOther”, “Unknown”))))))))



I haven’t checked this, so apologies for a typo. But basically, you can write an IF function using the above syntax. It will go through and anything with a -x number will be given the corresponding text (e.g., “Other5”). If one of the values isn’t listed, it will be given “Unknown” – see the last value and change it to whatever you want.

Better yet? I recommend downloading ArcGIS Insights Desktop. Open your data in the Data Engineering tool. Go to the field and select CHANGE DATA TYPE to String. Then do a FIND AND REPLACE on the field and replace every value with your preferred text. Very convenient in Data Engineering in Desktop version.

I hope this helps! Sorry if I misinterpreted your question. And thank you for using ArcGIS Insights!

Ian