topic Iterating through gdbs to export identically named tables in ModelBuilder Questions https://community.esri.com/t5/modelbuilder-questions/iterating-through-gdbs-to-export-identically-named/m-p/803548#M567 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have over 100 geodatabases that contain multiple feature classes and tables. Each gdb is named a little differently, but inside each are identically named feature classes and tables. I want to iterate through each gdb, extract one of the tables by name, and then export it to a different gdb.</P><P></P><P>I wanted to use iterate workspaces in model builder, but could not find how to then use the table to table tool. I'm able to modify scripts, but not great and creating them myself. If someone has a small script for this I'd be grateful!</P></BODY></HTML> Mon, 05 Oct 2020 19:05:43 GMT BillJacobs 2020-10-05T19:05:43Z Iterating through gdbs to export identically named tables https://community.esri.com/t5/modelbuilder-questions/iterating-through-gdbs-to-export-identically-named/m-p/803548#M567 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have over 100 geodatabases that contain multiple feature classes and tables. Each gdb is named a little differently, but inside each are identically named feature classes and tables. I want to iterate through each gdb, extract one of the tables by name, and then export it to a different gdb.</P><P></P><P>I wanted to use iterate workspaces in model builder, but could not find how to then use the table to table tool. I'm able to modify scripts, but not great and creating them myself. If someone has a small script for this I'd be grateful!</P></BODY></HTML> Mon, 05 Oct 2020 19:05:43 GMT https://community.esri.com/t5/modelbuilder-questions/iterating-through-gdbs-to-export-identically-named/m-p/803548#M567 BillJacobs 2020-10-05T19:05:43Z Re: Iterating through gdbs to export identically named tables https://community.esri.com/t5/modelbuilder-questions/iterating-through-gdbs-to-export-identically-named/m-p/1010218#M568 <P>You need to use sub-modelling, see help file. You iterate over workspaces, then in each workspace you iterate over the datasets, pulling out only the one you are interested in and that's the one you export. So a model within a model.</P> Wed, 16 Dec 2020 17:10:56 GMT https://community.esri.com/t5/modelbuilder-questions/iterating-through-gdbs-to-export-identically-named/m-p/1010218#M568 DuncanHornby 2020-12-16T17:10:56Z