What would cause ArcGIS Pro to place all csv data into one column? In excel, the data shows up in separate columns as expected. PS: The data is blurred intentionally.
ArcGIS Pro:
MS Excel:
and if that doesn't work then creating a schema.ini file is recommended
https://support.esri.com/en-us/knowledge-base/how-to-edit-the-field-properties-of-a-csv-file-in-arcgi-000024378
From my link
This is a deprecated tool. This functionality has been replaced by the Export Table tool.
but perhaps there is an issue with the replacement. Rule that possibility out as well using the 'deprecated' tool.
Running Export Table (which is the replacement for Table to table) on the csv file didn't solve the issue but Excel to table did. Once I converted the csv to excel and ran excel to table, the columns and data were split into their correct spots. Unfortunately though, I am unable to utilise excel in this way because the CSV data that I will be working with contains more that 1 millions rows. The data is upward of 4 millions rows.
If you have the data in Excel, did you use?
Excel To Table (Conversion)—ArcGIS Pro | Documentation
or if you have the csv then you can use it as the input to the following tool
Table To Table (Conversion)—ArcGIS Pro | Documentation
do both yield the same results?
If so then there may be something wrong with how the field names are being interpreted.
サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
