ArcMap is not recognizing the first column of my csv. Field name "AppID" and the values are all in the format of wxyz-#### (letters-numbers). I've checked the files for erroneous carriage returns. If I duplicate the first column in my csv before bringing it in to ArcMap, it comes in the way I wanted it to originally, but still doesn't recognize the very first column.
I should clarify that when I say the field is not recognized I don't mean it doesn't show up in arcmap, only that when the table is opened the second column is the first shown column of the attribute table and you have to manually scroll left to see the first column. I am able to perform joins with all other fields in the table, except for the one that is not recognized. When I join using that field, nothing is returned in the attribute table after the join. Exporting to dbf worked, but this is not an ideal solution since it makes my workflow longer
Best Answer
Perhaps the field is missing all together. Or some values are Null whereas others are not. If the second part, try changing the field format to Text within excel. It may be reading it as an integer field in ArcMap and making all the values with text in them Null