topic Re: TABLE NOT FOUND....???? in QlikView

TABLE NOT FOUND....????

Thu, 05 Sep 2013 10:00:24 GMT

Hi,

I have a question about scheduling creation tables...

With this script, i have an error: "Table not found" about the table RESA_AMA_TP2 when i create the table RESA_AMA.

Many thanks...

RESA_AMA_TEMP1:

LOAD ...............

FROM

[..\..\EXT_DATA\REC_COM\V4.00\RM\amadeus_*.xls]

(biff, embedded labels);

Qualify *;

EXTRACTIONS_TMP:

LOAD DISTINCT R_DateExtract

Resident RESA_AMA_TEMP1

Order by R_DateExtract;

Unqualify *;

Left join(EXTRACTIONS_TMP)

load EXTRACTIONS_TMP.R_DateExtract,

Rowno() as EXTRACTIONS_TMP.R_IDextract

Resident EXTRACTIONS_TMP

Order by EXTRACTIONS_TMP.R_DateExtract;

Unqualify *;

EXTRACTIONS:

LOAD EXTRACTIONS_TMP.R_DateExtract as R_DateExtract,

EXTRACTIONS_TMP.R_IDextract as R_IDextract

Resident EXTRACTIONS_TMP;

RESA_AMA_TP2:

LOAD *

RESIDENT RESA_AMA_TEMP1;

Left join load

R_DateExtract,

R_IDextract

Resident EXTRACTIONS;

RESA_AMA:

LOAD *

RESIDENT RESA_AMA_TP2;

Left join load

(R_IDextract)+1 as R_IDextract,

R_NbResa as R_NbResa_Prec,

R_NbOffres as R_NbOffres_Prec

Resident RESA_AMA_TP2;

Re: TABLE NOT FOUND....????

swuehl — Thu, 05 Sep 2013 10:11:58 GMT

Your table gets auto-concatenated to the source table because all field names are identical using LOAD * RESIDENT ...

You'll need an NOCONCATENATE LOAD prefix:

RESA_AMA_TP2:

NOCONCATENATE LOAD *

RESIDENT RESA_AMA_TEMP1;

But take care of QV trying to link your TP2 table to the TEMP1 table, creating a syn key (i.e. you may need to drop the first at the end).

Re: TABLE NOT FOUND....????

tresB — Thu, 05 Sep 2013 10:12:38 GMT

try this:

................

'''''''''''''''''

RESA_AMA_TP2:

LOAD *

RESIDENT RESA_AMA_TEMP1;

Left join load

R_DateExtract,

R_IDextract,

1 as Junk // this will prohibit autoconcatenate

Resident EXTRACTIONS;

Drop Table RESA_AMA_TP1

Drop field Junk;

'''''''''

;..........