nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Make query table error

AlonsoDiego

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

Encontre mais publicações marcadas com

Accepted answers

All comments

AlonsoDiego

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!

bixb0012

Do you have the bug number?

WesMiller

Joshua I spent a long time on the phone with ESRI on this issue. It is a known bug.

bixb0012

Interesting. I am running 10.4.1 and got your syntax to work. Why I didn't think it would work when I tried earlier was that I was using the expression builder to validate expressions and it generates an error: "There was an error with the expression. General function failure [Infraestructura] Too few parameters. Expected 3."

So, it seems to work, but there is a bug in the expression builder that says the expression isn't valid when tested.

WesMiller

I got it to work in 10.2 this way.

Infraestructura.idInfraestructura = InfraestructuraServicio.idInfraestructura AND Servicio.idServicio = InfraestructuraServicio.idServicio

AlonsoDiego

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!

bixb0012

I see what you are trying to do, and it generally seems right. Could you sanitize some subsets of data and post them?

Getting back to the other question I asked earlier. What happens if you put only one condition in at a time? Results, no results?

AlonsoDiego

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!

AlonsoDiego

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!

WesMiller

At 10.2 Make query table has a bug. Not sure what version your working with, but try removing the quotes from your field names.

bixb0012

If you would "Copy As Python Snippet" and paste the resulting ArcPy code here, it might help people reply since they would have more of the arguments.

Have you tried using just one or the other condition? Do you get results from doing both alone?

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.