POST
|
Hello everyone, At the end I did it! In Key Field Options I selected USE_KEY_FIELDS, but then I don't indicated any of them in the table below. It seems that ArcGIS is taken by default or through the expression. In this way, the tool has worked ...... Thanks to everyone!
... View more
06-30-2016
01:43 AM
|
1
|
0
|
605
|
POST
|
Hi Joshua, I uploaded my geodatabase to dropbox, here is the link: https://dl.dropboxusercontent.com/u/108321176/Infraestructura.mdb When I put only one condition the results are wrong... I hope someone can help me with this... Thanks!
... View more
06-28-2016
10:41 PM
|
0
|
1
|
1942
|
POST
|
Hi Joshua, Here I post the code: ... # Import arcpy module ... import arcpy ... ... ... # Local variables: ... Infraestructura = "Infraestructura" ... InfraestructuraServicio = "InfraestructuraServicio" ... Servicio = "Servicio" ... query2 = "query2" ... ... # Process: Make Query Table ... arcpy.MakeQueryTable_management("Infraestructura;InfraestructuraServicio;Servicio", query2, "ADD_VIRTUAL_KEY_FIELD", "", "Infraestructura.Shape #;Infraestructura.idInfraestructura #;Servicio.idServicio #", "Infraestructura.idInfraestructura = InfraestructuraServicio.idInfraestructura AND Servicio.idServicio = InfraestructuraServicio.idServicio" Thanks!
... View more
06-28-2016
10:18 AM
|
0
|
3
|
1942
|
POST
|
Hi Wes, I'm working with 10.3 version of ArcGIS.... I try removing the quotes but the table don´t have any records too... Thanks!
... View more
06-28-2016
10:15 AM
|
0
|
0
|
1942
|
POST
|
Hi, I need to join one feature class and one table. This is a one to multiple join, therefore, my only option seems to be by creating a query table. My problem is that the fields I want to join do not seem to be matched properly when I run the query table tool. I've tried using the following expression in the query table expression field to indicate that these are the fields to be joined: ("Infraestructura.idInfraestructura" = "InfraestructuraServicio.idInfraestructura") AND ("InfraestructuraServicio.idServicio" = "Servicio.idServicio") But the layer result is empty. I think I may be doing something wrong (perhaps the problem is with my query), but I'm not sure what. When I verify my query in the query builder window, I keep getting a message saying The expression was verified successfully but no records were returned which does not make any sense as there should definitely be some matches. Thanks
... View more
06-28-2016
04:45 AM
|
0
|
15
|
8071
|
Title | Kudos | Posted |
---|---|---|
1 | 06-30-2016 01:43 AM |
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:24 AM
|