Select to view content in your preferred language

Import CSV to EGDB — Convert AREA field name to AREA_1, not OWNER.TABLE.AREA

166
1
10-30-2024 07:57 AM
Status: Open
Labels (1)
Bud
by
Esteemed Contributor

ArcGIS Pro 2.9.5; Oracle 18c 10.7.1 EGDB:

I've imported a .CSV to an EGDB using Table to Geodatabase. The .CSV had an AREA field which is a reserve word in Pro. In the Fields View, I can see Pro has converted AREA to ENGINEERING.WORKORDERS.AREA. But Pro behaves awkwardly when there is a period in a field name. See Esri Case #03757242 - Import .CSV using Table to Geodatabase: AREA field - unexpected behavior in Fields View.

Idea: Instead of fully qualifying a reserve word field name with the owner name and the table name, suffix the reserve word field name with _1 or something similar: AREA_1. I think that would behave better in Pro compared to a field name with periods.

1 Comment
SSWoodward

Thanks for this Idea @Bud

This does not directly address this issue you've raised, but have you tried using the export table GP tool?  This tool gives you much more granular control of how your data is transferred.