topic Re: Export table with only visible fields in ArcGIS Pro Questions

Export table with only visible fields

WarrenMedernach — Wed, 30 Aug 2017 16:51:40 GMT

Hello all,

I'm trying to export tables with only the columns that are visible, and the numeric formatting assigned to those columns.

It doesn't seem to matter which export method chosen (Table View>Export>Copy Rows GP, Table To Table, etc), they all seem to export all of the fields and do not honor the numeric column formatting?

I simply want to generate an X,Y,Z file without any other columns... Am I missing something very obvious here?!?!

Warren

Re: Export table with only visible fields

JayantaPoddar — Wed, 30 Aug 2017 19:48:21 GMT

While executing Table To Table—Conversion toolbox | ArcGIS Desktop , you could delete the unwanted fields from Field_mapping (Optional) parameter.

Re: Export table with only visible fields

WarrenMedernach — Wed, 30 Aug 2017 20:11:27 GMT

Thanks Jayanta, but unfortunately that doesn't appear to be working as expected, as I only had the required fields in the Output Fields selected, and it still exports this OID field...

Re: Export table with only visible fields

DanPatterson_Retired — Wed, 30 Aug 2017 23:31:07 GMT

I think OID field will go out by default because the expectation is you might want to differentiate the features. There are coding solutions using numpy, but I guess you have to decide how inconvenient it is to have the extra baggage and whether you can just delete what is superfluous once you use it elsewhere.

Re: Export table with only visible fields

shan_sarkar — Fri, 01 Sep 2017 06:36:22 GMT

OID, OBJECTID will always be exported as that is the default indexed system generated field when ArcGIS Desktop or ArcGIS Pro is involved.