AnsweredAssumed Answered

ArcGIS Online is converting my table's text field to 'integer' data type.

Question asked by PersefoniKapotas on Oct 24, 2019
Latest reply on Oct 28, 2019 by PersefoniKapotas

I am trying to add a table to my content as a hosted layer.  It is an excel table that has a column with numeric values stored as text.  I did check to make sure that it was a text/string field.  AGOL automatically converts the field to 'integer' and I can't find a way to convert it back to string, which I have to do because I want to join the table to a layer using this field.  I tried bringing it into arcgis pro first, and arcgis pro recognized it as a string field so I didn't go any further with that idea.  I ended up adding a new string field in agol, and copying over the data (i had to do some calculations to add a 0 in front, etc.). But i'm wondering if there is an easier/more straightforward way. 

 

Why doesn't AGOL respect the data types from the original table?

Outcomes