<Null> Reading in pop-up where table has data

ClaireK

Hi, I am using ArcGIS Pro and have created a database in excel then saved it as a CSV file which I have brought into ArcGIS. In bringing in the data I am able to convert to XY points for my latitude and longitude columns. However some of the other columns that are numeric read as <Null> on the Pop-up for the point information. I have tried to correct this by changing that column to either number or text in the CSV file and reimporting it. When I do this it either does not fix the problem or no longer has the option for my latitude and longitude columns in the drop-down to convert to the x-y points. 

Help.PNG

00_02.pdf

saraew_1-1618349551455.png

shan_sarkar

Hi Claire,

ArcGIS doesn’t play well with special characters in Column name. In your screenshot I see there is a field named IC (MW), you would need to remove the parentheses and the spaces. You may replace it with an underscore as that is acceptable, so your field name would look something like IC or IC_MW.

You can later use the Alias field name as IC (MW) as ArcGIS doesn’t read the Alias field names for anything other than display purposes.

You may refer the Define fields in tables