topic Re: Sort_management in for loop in Python Questions

Sort_management in for loop

AdityarajChavada — Tue, 12 Mar 2013 13:25:25 GMT

Hello, I like to convert tables (100+) living in access database to a geodatabase table, sorting them and deleting unnecessary fields in each table at the same time. I figured I use the Sort_management method to convert and sort the tables followed by DeleteFieldd_management method to delete the fields. Here is the code that I have written,

import arcpy  from arcpy import env  env.workspace = "E:\Database Project\ACS Estimate 2011\ACS 2011 Tables.mdb"  tableList = arcpy.ListTables()  for table in tableList:      out_dataset = "E:\Database Project\ACS Estimate 2011\Data\To Database\Seq Tables.gdb"      #Process: Sort     arcpy.Sort_management(table, out_dataset, "GEOID ASCENDING", "UR")      #Process: Delete Field     arcpy.DeleteField_management(out_dataset, "FILEID;FILETYPE;STUSAB;CHARITER")

I am getting the following error message,
[ATTACH=CONFIG]22543[/ATTACH]

Re: Sort_management in for loop

RaphaelR — Tue, 12 Mar 2013 13:38:33 GMT

the link to your attachment doesn´t work for me:
"Invalid Attachment specified. If you followed a valid link, please notify the administrator"

Re: Sort_management in for loop

AdityarajChavada — Tue, 12 Mar 2013 14:10:30 GMT

I am not sure what happened but I re-added the error message. Let me know if it works now. Thank you.

Re: Sort_management in for loop

RaphaelR — Tue, 12 Mar 2013 14:21:02 GMT

your out_dataset points to a gdb, not a feature classs or table as required.

you could try this, which should give each table in the output database the same name it had in the input database.

out_dataset = r"E:\Database Project\ACS Estimate 2011\Data\To Database\Seq Tables.gdb" + "\\" + table

edit: forgot to make it a raw string.