I am trying to join two tables that each exist in multiple geodatabases, and then export the joined product to a .dbf table. This works until I try to use Iterate Workspace to loop over multiple geodatabases.
I have the basic process working in ArcGIS Pro 2.2.0 as a tool that I can run from inside ModelBuilder. The tool contains two input tables that use inline substitution to get the path from a variable that contains the input geodatabase path. The tool then makes Table Views from both Tables, performs the join and exports as .dbf table to a separate input folder (see image). This all works well for that one input geodatabase.
I then tried to replace the input geodatabase with the output geodatabase from an Iterate Workspaces iterator (using file geodatabases only), again using inline substitution to get that output geodatabase be part of the input table names. That does not work for some reason. I considered using Parse Path, but realized that that would cut the input geodatabase down to its own path and then its name - that seems useless.
I recognize that the Output Geodatabase from Iterate Workspaces has the 'dataset' symbology in ModelBuilder (green ellipse) whereas the geodatabase name that I currently provide as an input to the working part of the tool has the 'variable' symbology (blue ellipse). I wonder whether that difference is part of the problem, but don't know how to fix that.