Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

TABLE NOT FOUND....????

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;

1 Solution

Accepted Solutions
MVP
MVP

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

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).

2 Replies
MVP
MVP

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

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).

MVP
MVP

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

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;

'''''''''

;..........

Community Browser