topic Re: Table Exports to CSV file in Data Management Questions

Table Exports to CSV file

KRobinson-GIS — Mon, 20 May 2024 17:56:16 GMT

Hello All,

I was given a seemingly simple task at work to produce a .txt file with a set of data displayed in ascending order of a specific field of a feature class.

I quickly found that I was not able to export a table from Pro to display the data in the order that I wanted. Every time I exported, the resulting table would be in ascending order of the OBJECT ID field, I was never able to export the table in ascending order of the field of my choosing.

I did manage a work around in that I exported the data as a CSV file, opened it in Excel, deleted the column that contained the OBJECT ID field, then saved the file as a .txt file, opened it in Notepad ++, and with my target field now being the first column, I sorted the data in ascending order using the tool in Notepad ++.

I was just curious if anyone has come across the same issue and knows of a way to export a table in ascending order of a field other than the OBJECT ID field, straight from Pro?

Thanks for any insights!

Re: Table Exports to CSV file

CodyPatterson — Mon, 20 May 2024 17:59:36 GMT

Hey @KRobinson-GIS

I'm away from my work machine currently and am not able to test my theory entirely, but I have an idea!

Is it possible for you to swap the column locations to the desired ascending/descending column instead of the OBJECTID column? Here is what I mean:

Hope that helps!

Cody

Re: Table Exports to CSV file

BlakeTerhune — Mon, 20 May 2024 18:59:34 GMT

You can use Python to open a search cursor using the fields in the order you want with a sql_clause parameter to sort on the field you want. Iterate through each row of the cursor and write the data to your text file. You can even use the Python CSV module.

Re: Table Exports to CSV file

RhettZufelt — Mon, 20 May 2024 19:42:03 GMT

From what I can tell, They will always be exported by sort order of OBJECTID. You can use the Sort GP tool (or python) to sort the table on a field that you want (which creates a new table/FC), then export that new, exported table as the OBJECTID's will be relative to the new 'sorted' field.

If nothing else works, you can do the workaround without the step saving to .txt file.

In Excel, open csv, sort by the field you want, save.

Re: Table Exports to CSV file

HabtamneshGoite — Tue, 21 May 2024 04:50:39 GMT

You can do it all in pro. when Exporting a table of the feature class, it has options to choose fields you want to include as well as sorting.