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?