topic Re: arcpy maketableview in Python Questions

arcpy maketableview

JeffGodfrey — Wed, 24 Sep 2014 18:25:23 GMT

How do I hide certain fields when I make a table view, so when I export the table I only get the fields I need?

I have the following code in python:

arcpy.MakeFeatureLayer_management(sde_CHELAN_Property_Polygons, CHELAN_Property_Polygons_Lay, "", "", "OBJECTID OBJECTID HIDDEN NONE;PLAT_NO PLAT_NO HIDDEN NONE;SP_ID SP_ID HIDDEN NONE;......

I have also attached the complete python script.

When I export my table to excel I still get all the fields.

Thank you

Jeff Godfrey

Re: arcpy maketableview

JakeSkinner — Wed, 24 Sep 2014 19:07:19 GMT

Hi Jeff,

The Make Feature Layer and Make Table View tools only hide the fields, they don't actually delete them. What I would recommend doing is adding the 'Table to Table' tool to your model, specifying the join output as the input table.

The field mapping may not update correctly within this tool at first. It should show all fields and not just the visible ones. After setting all the parameters within this tool, validate your model (Model > Validate Entire Model). Then, click on the Table to Table tool within your model again. You should now see all fields listed. You can then delete the fields you don't want.

After the field mapping is updated, you can use the Table to Excel tool to create the final output.

Re: arcpy maketableview

JeffGodfrey — Wed, 24 Sep 2014 21:17:08 GMT

Jake

Thanks for the help. The table to table tool let me remove unwanted fields from my final product, the excel spreadsheet.

Thanks

Jeff

Re: arcpy maketableview

JakeSkinner — Thu, 25 Sep 2014 10:31:09 GMT

Great, glad this worked for you. If you get a chance, please mark this thread as answered to help other users in the community. Thanks!