I added a csv datasource to my project, but after adding it I found two problems. The first is that a column filled with numeric data had a "Grand Total" entry in the bottom row, so ArcGIS Pro intrepreted the column as text instead. The same column also had a non-descriptive heading label. I removed the datasource from ArcGIS Pro, open the csv file in Excel, remove the grand total row, and change the column heading to something more descriptive, then save the file. I go back into ArcGIS Pro and re-add the datasource. To my frustration, ArcGIS Pro is still calling the column by its old label and still interpreting it as text. Why is this application so frustrating??? How can I get it to read the file without deleting everything and starting over with a new project?
Thanks for the reply Dan.
If I remove it from the project, save the project, then restart and reopen the project, it still reads the field as text.
So I went into Windows Explorer and changed the filename. I tried to re-add the file, but the ArcGIS Pro "Add Data" dialog still shows me the old file name. If I try to open that, I get an error ("The file doesn't exist"...no $%#&*, I just renamed it). I have to restart ArcGIS Pro for it to see the file with the new name. Unbelievable.
After I have restarted the application, reopened my project, and re-added the renamed file, the application FINALLY reinterprets the data, realizes that there is no longer a call that says "Grand Total" and correctly interprets the column as numeric. At this point I've only torn out half the hair on my head.
Just for kicks I try making a new project, but in the dialog to set the path for my new project, I cannot create a new folder. I have to go back to Windows Explorer to create a new folder for my project. That's why my company is paying thousands of dollars for an ArcGIS license....because we want to have to open a whole separate program to create a folder (*sarcasm*).
ESRI software makes me reconsider my career choice as an urban planner.
Matt, what version of Pro are you using?
In the current version, 2.3.2, it is possible to create a new folder when I'm pathing to where I want to create a new project:
You removed the file from the project, then saved the project?
Close and restart does nothing?
Try a simple rename of the *.csv, then re-add
Add the file to an empty project.
Any of those work?