https://community.esri.com/t5/arcgis-pro-questions/delete-fields-in-the-closest-facility-routes-layer/m-p/1075958#M42952 <P>Hello. I'm using ArcGIS Pro to perform the closest facility analysis. After the analysis is completed, I would like to use "table to excel" to export the fields in the&nbsp;closest facility/routes layer to excel. Some fields in the layer have no values, eg. StartTime and EndTime, because I didn't specify them when I ran the analysis. Therefore, I would like to delete these two fields so that I can save time when exporting the table to excel. However, I am not able to delete them. Could anyone tell me how I could delete them? Thank you.</P> Tue, 06 Jul 2021 17:57:24 GMT zhongying_gan 2021-07-06T17:57:24Z https://community.esri.com/t5/arcgis-pro-questions/delete-fields-in-the-closest-facility-routes-layer/m-p/1075958#M42952 <P>Hello. I'm using ArcGIS Pro to perform the closest facility analysis. After the analysis is completed, I would like to use "table to excel" to export the fields in the&nbsp;closest facility/routes layer to excel. Some fields in the layer have no values, eg. StartTime and EndTime, because I didn't specify them when I ran the analysis. Therefore, I would like to delete these two fields so that I can save time when exporting the table to excel. However, I am not able to delete them. Could anyone tell me how I could delete them? Thank you.</P> Tue, 06 Jul 2021 17:57:24 GMT https://community.esri.com/t5/arcgis-pro-questions/delete-fields-in-the-closest-facility-routes-layer/m-p/1075958#M42952 zhongying_gan 2021-07-06T17:57:24Z https://community.esri.com/t5/arcgis-pro-questions/delete-fields-in-the-closest-facility-routes-layer/m-p/1075964#M42953 <P>They may be bound to the analysis itself.&nbsp; If saving, rebooting and reopening the table still doesn't allow you to delete them... it would have been faster to just delete them in excel</P> Tue, 06 Jul 2021 18:07:31 GMT https://community.esri.com/t5/arcgis-pro-questions/delete-fields-in-the-closest-facility-routes-layer/m-p/1075964#M42953 DanPatterson 2021-07-06T18:07:31Z https://community.esri.com/t5/arcgis-pro-questions/delete-fields-in-the-closest-facility-routes-layer/m-p/1075980#M42956 Try turning off the fields you don't want to export before exporting the table to Excel. I believe the process only exports the fields that are visible.<BR /> Tue, 06 Jul 2021 18:39:36 GMT https://community.esri.com/t5/arcgis-pro-questions/delete-fields-in-the-closest-facility-routes-layer/m-p/1075980#M42956 JenVuturo-Brady 2021-07-06T18:39:36Z https://community.esri.com/t5/arcgis-pro-questions/delete-fields-in-the-closest-facility-routes-layer/m-p/1076142#M42973 <P>Hello,&nbsp;</P><P><SPAN>Thank you for your help. Rebooting and reopening the table still doesn't allow me to delete certain fields. I guess I'll have to export all the fields.</SPAN></P> Wed, 07 Jul 2021 00:00:56 GMT https://community.esri.com/t5/arcgis-pro-questions/delete-fields-in-the-closest-facility-routes-layer/m-p/1076142#M42973 zhongying_gan 2021-07-07T00:00:56Z https://community.esri.com/t5/arcgis-pro-questions/delete-fields-in-the-closest-facility-routes-layer/m-p/1076143#M42974 <P>Thank you for your reply. By turning off the field, do you mean hiding the field? I have hidden the fields before&nbsp; performing "table to excel". However, the fields that are hidden have still been exported to excel.</P> Wed, 07 Jul 2021 00:02:33 GMT https://community.esri.com/t5/arcgis-pro-questions/delete-fields-in-the-closest-facility-routes-layer/m-p/1076143#M42974 zhongying_gan 2021-07-07T00:02:33Z https://community.esri.com/t5/arcgis-pro-questions/delete-fields-in-the-closest-facility-routes-layer/m-p/1076147#M42976 <P>Easy to delete in excel <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P> Wed, 07 Jul 2021 00:08:06 GMT https://community.esri.com/t5/arcgis-pro-questions/delete-fields-in-the-closest-facility-routes-layer/m-p/1076147#M42976 DanPatterson 2021-07-07T00:08:06Z