Field matching in Field Mapping for the Append geoprocessing tool.

11-23-2020 10:05 AM
Status: Open
Labels (1)
Occasional Contributor III

When I use the append tool, it's usually part of my ETL process. In that process I have a layer joined with a table that I am appending to another layer. Because of that join, my source layer field names are qualified and look like this - sde.DBO.Ownershiptable.NAME and my target layer field is just NAME. The field mapping component of the append tool doesn't auto match the fields because of the join. I would love it if the append tool looked at just the actual field name instead of the fully qualified field name when auto-matching field names. This could be added to the Environments tab of the tool.

Tags (2)
1 Comment

Good one Jeff: I second the idea.  Field mapping has always been a tough nut to crack. 

Instead of a join, could you use the turbo charge approach from Fairhurst?  I use that almost daily it seems: