I'm new to ArcGIS and was wondering if someone could help me with my SQL expression.Essentially, I'm using model builder to iterate over several tables and Make Query table for each one. I'm trying to join my tables to shapefiles. Normally what I would do is are far as the SQL expression is:column_name_of_table = column_name_of_my_shapefile
this would work just fine if I use the Make Query table one at a time for each table.However, I'm having an issue with the SQL expression when I try to iterate over multiple tables. The column name that I'm using to join to the shapefile colmun name are exactly the same, however the name of the Table itself is not. For example, I have 4 tables labeled: Out0, Out1, Out2 and Out3. They all share the same field name for the field that I want to join to the shapefile. Each field name is named Locality. That means that the actual field name is Out0.Locality, Out1.Locality, Out2.Locality and Out3.Locality. The shapefile's field name always stays the same, MSA_Locality. So when I try to write the SQL expression and iterate it Out0.Locality = MSA_Locality will not work for Out1.Locality = MSA_Locality or so on.How could I fix it so that the SQL expression is consistent regardless of the table name? I would greatly appreciate any help/feedback!
أكثر...
this would work just fine if I use the Make Query table one at a time for each table.However, I'm having an issue with the SQL expression when I try to iterate over multiple tables. The column name that I'm using to join to the shapefile colmun name are exactly the same, however the name of the Table itself is not. For example, I have 4 tables labeled: Out0, Out1, Out2 and Out3. They all share the same field name for the field that I want to join to the shapefile. Each field name is named Locality. That means that the actual field name is Out0.Locality, Out1.Locality, Out2.Locality and Out3.Locality. The shapefile's field name always stays the same, MSA_Locality. So when I try to write the SQL expression and iterate it Out0.Locality = MSA_Locality will not work for Out1.Locality = MSA_Locality or so on.How could I fix it so that the SQL expression is consistent regardless of the table name? I would greatly appreciate any help/feedback!
أكثر...