topic Re: Appending from a feature class to another removes spaces in string attribute? in ArcGIS Pro Questions

Appending from a feature class to another removes spaces in string attribute?

DanielLane — Wed, 22 Mar 2023 00:33:44 GMT

I am trying to append a select query to an empty feature table, when I do this the string field (Species Name) has the spaces removed and is all lower case?

Original data (SpeciesName):

After append to existing table the data looks like this:

I have tried this with other string fields and the result is the same for all.

What can I do to fix this?

Re: Appending from a feature class to another removes spaces in string attribute?

ChristopherCounsell — Wed, 22 Mar 2023 03:38:23 GMT

Is there a domain? If you edit the data, do you get a drop-down or is it open text?

If there is a domain, it's likely that the domain values are being passed. Coded domain values can't have special characters, including spaces, and are generally shown in tables using their domain label.

You can use Arcade expressions to choose whether the labels or values are shown (e.g. in pop-ups) but I don't think it can be used in the append tool.

You may be able to fix it by applying the same domain to the destination field. If the tables are in the same geodatabase, they can use the same domain list, to help ensure the values are aligned.

https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/create-modify-and-delete-domains.htm

Re: Appending from a feature class to another removes spaces in string attribute?

DanielLane — Wed, 22 Mar 2023 04:47:12 GMT

Yes, that was it!!!

Thankyou