I want to join a relationship table (same database, not in sde) to an ArcSDE feature class to distplay only needed features. This has to be done multiple times according to every row (value) of an other table (same database, not in sde too).
The first step works, but I have to make a query layer first as it looks like I cant make joins with tables not in the sde.
I do not want to create ~500 query layers (for the joins), so I'm trying to use ModelBuilder to create the query layers (and maybe also to make the joins in the future).
The figure below shows the model that Ive created so far (at the moment I dont know if this approach would generally work/do its job).
I want to use the value catid to perform the query in the Make Query Layer (2).
How should/could I do that?
Here some pseudothings
table a; -- contains some categories
table b; -- =m:n relationship table for "a" and "c"
feature class c;
table d_*; --contains all data from "b" related to a single category (row) of "a"
foreach row in a
{
create table d_*;
}
In psql this would be kind of simple, but I need this done on the ArcGIS level as the join of the feature class relates on this.
I was also thinking about python, because using a programming language this would also be kind of simple -- but I have no idea about python and I thought i could avoid scripting.
