I am importing a .csv file (2 columns, 291 rows) into ArcMap 10.2 using ArcCatalog 10.2 to drag the .csv into ArcMap. The second column of the .csv is a floating point number (range is [0-1]), however Arc is treating that column as an int. That is: I can view the column as numeric with decimal places in Excel, text editor, etc., but when I open the table in ArcMap the column is reduced to 0, 1 or null. All non integers are replaced to null.
How to I ensure that Arc reads the column as a float?
I have tried the following, but none have worked:
أكثر...
How to I ensure that Arc reads the column as a float?
I have tried the following, but none have worked:
- Re-ordering the observations so that observations with decimals are in the first eight rows (since I believe Arc looks at the first eight rows to determine data type).
- Editing the scheme.ini file to indicate column 2 has the datatype float. (But I may not be doing this correctly.)
- Saving the .csv file with an alternative delimiter.
- Changing the column in Excel from numeric to text. Changing the numeric column in Excel to different numbers of places after the decimal.
أكثر...