topic Re: Iterators for Multiple Inputs in ModelBuilder in ModelBuilder Questions

Iterators for Multiple Inputs in ModelBuilder

GinnyHarris1 — Fri, 30 Mar 2018 22:18:39 GMT

I am attempting to run GeodatabaseSchemaCompare across multiple geodatabases. Each database has its own unique "test" (template) database. And, because the tool just outputs a folder with the same name, it needs to be in its own folder.

Basically, what I want it to do is compare Database1 to Template1, output the report into Folder1. Then, Database2 to Template2, output the report to Folder2, on down the line for all 100 databases.

Using the workspace iterator I was able to get to compare Database1 to Template, then write the Schema to Folder, then compare Database2 to Template, and then overwrite the first report to create another report in Folder.

I know you can not have more than one iterator in a model when using model builder. Because of this, is my task impossible? Am I going to have to go bother my Python guy to see what he can develop for me?

Re: Iterators for Multiple Inputs in ModelBuilder

curtvprice — Sat, 31 Mar 2018 05:35:06 GMT

The way to nest loops in Model Builder is to embed models in one another. Both the main model and submodel have their own iterators.

Integrating a model within a model—Help | ArcGIS Desktop

If You Are Stuck At If‌

Re: Iterators for Multiple Inputs in ModelBuilder

GinnyHarris1 — Mon, 02 Apr 2018 19:55:56 GMT

I have attempted to use the examples included in the reply, and I just can't figure out where I am going wrong. Each iterator in the submodels works when it is in the main model. I just can't figure out how to get them to work when I add it is as a submodel. Basically what happens is that it seems it iterate through my whole list of databases, but then only runs the compare on the very last databases in the list and puts them in the folder on the list. Based on my research I'm assuming what I'm missing are preconditions. But, I haven't quite figured out where those fit into this.

Because it is sensitive data, I can't include that. But, I have attached my toolbox.

Re: Iterators for Multiple Inputs in ModelBuilder

curtvprice — Tue, 03 Apr 2018 16:09:28 GMT

Be sure you are using generating unique output names (ie dataset%n%) and using the Collect Values tool on the submodel, or all you get out is the last result after the submodel iterates.