topic Inner join with resident tables, table not found error. in QlikView

Inner join with resident tables, table not found error.

Thu, 17 Dec 2009 22:24:42 GMT

Hi all,

I have this script and i'm getting the 'Table Not Found' error. Basically I load a resident table, and then when i try to join it (inner join) with another table i get this error. Can anyone tell me what its wrong here?

//load the table:

TKT_ANT_TMP:

LOAD MAX(TicketId) AS TicketActual,
NumeroAbonado
FROM Int_Item.QVD (qvd)
GROUP BY NumeroAbonado;

TktAnterior:

LOAD PREVIOUS(TicketActual) AS TicketAnterior,
TicketActual,
NumeroAbonado
RESIDENT TKT_ANT_TMP;
DROP TABLE TKT_ANT_TMP;

//then i try to do an inner join between the resident and another table:

TicketAnterior_tmp:

LOAD TicketAnterior,
TicketActual,
NumeroAbonado
RESIDENT TktAnterior_tmp;
DROP TABLE TktAnterior_tmp;

inner join (TicketAnterior_tmp)

LOAD TicketId AS TicketAnterior,
ProcessInstanceId,
Ticket_FechaCierre as FechaCierreTktAnt
FROM Int_Tickets.QVD (qvd);

//here i get: TABLE NOT FOUND (TicketAnterior_tmp)

Inner join with resident tables, table not found error.

Fri, 18 Dec 2009 00:00:21 GMT

Hi,

by default, If you load exactly the same list of fields (same number of field and same name) than an existing table, QlikView concatenate your new load in the existing table. When you load TktAnterior, QlikView concatenate data to the existing table TKT_ANT_TMP and don't create TktAnterior.

The NOCONCATENATE instruction (see below) should solve the problem


TktAnterior:

LOAD PREVIOUS(TicketActual) AS TicketAnterior,
 TicketActual,
 NumeroAbonado
RESIDENT TKT_ANT_TMP;
DROP TABLE TKT_ANT_TMP;
//then i try to do an inner join between the resident and another table:
TicketAnterior_tmp:

NOCONCATENATE LOAD TicketAnterior,
 TicketActual,
 NumeroAbonado
RESIDENT TktAnterior_tmp;
DROP TABLE TktAnterior_tmp;

Best regards

Inner join with resident tables, table not found error.

Fri, 18 Dec 2009 00:11:38 GMT

Thanks a lot for your answer Bertrand!

Now works fine, i didn't know about the concatenate by the default.

Great to have this forums!