https://community.esri.com/t5/arcgis-pro-ideas/field-matching-in-field-mapping-for-the-append/idi-p/1004047 <P>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.</P> Mon, 23 Nov 2020 18:06:52 GMT JeffWard 2020-11-23T18:06:52Z https://community.esri.com/t5/arcgis-pro-ideas/field-matching-in-field-mapping-for-the-append/idi-p/1004047 <P>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.</P> Mon, 23 Nov 2020 18:06:52 GMT https://community.esri.com/t5/arcgis-pro-ideas/field-matching-in-field-mapping-for-the-append/idi-p/1004047 JeffWard 2020-11-23T18:06:52Z https://community.esri.com/t5/arcgis-pro-ideas/field-matching-in-field-mapping-for-the-append/idc-p/1004060#M14385 <P>Good one Jeff: I second the idea.&nbsp; Field mapping has always been a tough nut to crack.&nbsp;</P><P>Instead of a join, could you use the turbo charge approach from Fairhurst?&nbsp; I use that almost daily it seems:&nbsp;&nbsp;<A href="https://community.esri.com/t5/python-blog/turbo-charging-data-manipulation-with-python-cursors-and/ba-p/884079" target="_blank">https://community.esri.com/t5/python-blog/turbo-charging-data-manipulation-with-python-cursors-and/ba-p/884079</A></P><P>&nbsp;</P> Mon, 23 Nov 2020 18:47:49 GMT https://community.esri.com/t5/arcgis-pro-ideas/field-matching-in-field-mapping-for-the-append/idc-p/1004060#M14385 JoeBorgione 2020-11-23T18:47:49Z