Add Fields (multiple) could import from existing table or feature class template

TimMinter

I'm building a ModelBuilder model and I want to re-use the fields in an existing geodatabase table to populate and then edit the "Add Fields (multiple)" GP tool. I will craftily move those fields around to change their order ;-), change the definitions on a couple of them, remove some, and add some. Do I want to manually enter all 79 (or worse) of those fields and risk going over the limit of however many clicks I have left in my carpal tunnels? No, I do not. Nope. What I want is to import the fields from my template table to populate the "Add Fields (multiple)" GP tool and then burn some clicks on the arguably valuable changes. Can I do it? Nope, not yet in ArcGIS Pro 2.8.2 (2.8.3 is out, but release notes don't suggest an update would help me with this idea). Would love to be able to do it soon.

Stringing up those two GP tools does not populate the "Add Fields (multiple)" field list. Tried, failed.

tim

BillFox · ‎10-11-2021

Will a join and export help you?

or maybe create new with import from

TimMinter · ‎10-18-2021

HI Bill,

Unfortunately, no. I need a way to inject changed table schemas, including field order, into a relatively static enterprise geodatabase schema that uses db views to ETL data from an incoming spreadsheet that occults the source system schema (it shall forever be unknown to me/us) to a product set of enterprise geodatabase feature classes and tables that staff and various apps/systems use. When the source system has schema changes that impact my ETL, I have to go and jiggle the staging tables that receive the spreadsheet content, ArcGIS-friendly tables with curated field definitions (and order), and the db views so that I don't have to change the schema for the product feature classes and views and bust a bunch of stuff. Whew.

My idea above would help because I could pop open the Add Fields (multiple) GP tool in a model, adjust the field definitions (and order), generate a schema that matches the source system changes, and carry on with the change. As it stands, I can do that, but it takes days and thousands of clicks to set it up the first time. When there are major source system changes, a fresh setup helps avoid errors. If I could point the tool at the staging tables when setting up, then far fewer clicks would be involved and the opportunities for errors decrease.

tim

DrewFlater · ‎02-22-2022

This will be available in ArcGIS Pro 3.0.

KoryKramer · ‎06-24-2022

This functionality has been added in ArcGIS Pro 3.0. See Ideas in ArcGIS Pro 3.0 to see this and all of the other ideas you can look forward to when you upgrade.

Also be sure to check out the What's New documentation: https://pro.arcgis.com/en/pro-app/latest/get-started/whats-new-in-arcgis-pro.htm

TimMinter · ‎07-13-2022

Nice! Thanks @KoryKramer!