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 NO FOUND, TABLA NO ENCONTRADA

hI EVERYBODY, PLEASE HELP ME WITH THIS MISTAKE. MY SCRIP IS:

TMP7:

LOAD  Distinct "ref_num",

          "F_Apertura",

          "F_Resuelto",

          Grupo,

          Categoria_SLAIR,

          SLA_GRUPOS,

Date,

Start,

End

Resident SLA

while daystart("F_Resuelto") >= daystart("F_Apertura")+iterno()-1;

left join (SLA)

LOAD

Distinct "ref_num",

fabs(interval(sum(End-Start))*24) as DurationScript2

Resident TMP7  where WeekDay(Date)<5 and not match(Date,$(vHol));

drop table TMP7;

BUT WHEN I LOAD MY SCRIP, IT SHOWS ME A MESSAGE LIKE THIS:

Tabla no encontrada

left join (SLA)

LOAD

Distinct "ref_num",

fabs(interval(sum(End-Start))*24) as DurationScript2

Resident TMP7  where WeekDay(Date)<5 and not match(Date,41130,41140)

PLEASE HELP ME.

REGARDS

DAPHNE.

Tags (3)
9 Replies
sivarajs
Valued Contributor II

Re: TABLE NO FOUND, TABLA NO ENCONTRADA

Your joining to a different table under TMP7 table

Make sure where you want to join

do

left join(TMP7)

Not applicable

Re: TABLE NO FOUND, TABLA NO ENCONTRADA

BUT THE MESSAGE IS THE SAME WHN I DO THIS CHANGE. I HAVE A TABLE CALL SLA.

Tabla no encontrada

left join (TMP7)

LOAD

Distinct "ref_num",

fabs(interval(sum(End-Start))*24) as DurationScript2

Resident TMP7  where WeekDay(Date)<5 and not match(Date,41130,41140)

SLA:

NoConcatenate

LOAD

          "ref_num",

          "F_Apertura",

          "F_Resuelto",

          Grupo,

          Categoria_SLAIR,

          SLA_GRUPOS,//-------- Start Multiple Select Statements ------

Date,

Start,

End

FROM

C:\Users\dnunez\Desktop\Pruebas_QV\PJ_QV_SD_Server\SLA_QVD.QVD(qvd);

Not applicable

Re: TABLE NO FOUND, TABLA NO ENCONTRADA

try removing 'nocontenate' for table SLA

Not applicable

Re: TABLE NO FOUND, TABLA NO ENCONTRADA

Hi,

Try this

SLA:

LOAD .....

FROM.......

NoConcatenate

TMP7:

LOAD ......

And then join tables.

Best,

Yani

Not applicable

Re: TABLE NO FOUND, TABLA NO ENCONTRADA

GRACIAS POR LA RESPUESTA, PERO EL TMP7 E SUNA TABLA TEMPORAL , ALGUNA OTRA SUGERENCIA PLEASEEEE

Not applicable

Re: TABLE NO FOUND, TABLA NO ENCONTRADA

Hi,

I`m not sure that understand you correct, but if you want the table TMP7 to be temporary you can DROP it after

"left join (SLA)

LOAD

Distinct "ref_num",

fabs(interval(sum(End-Start))*24) as DurationScript2

Resident TMP7  where WeekDay(Date)<5 and not match(Date,$(vHol));

drop table TMP7"

Best,

Yani

Not applicable

Re: TABLE NO FOUND, TABLA NO ENCONTRADA

Hi Yani, thank for answer

I drop my pemporary table but when i load my script, an error message apears and say that my table SLA in not found, i dont understand why!, i have my table called SLA BEFORE to create my temporary table TMP7 Smiley Frustrated please help me.

Not applicable

Re: TABLE NO FOUND, TABLA NO ENCONTRADA

this is my table called SLA:

SLA:

NoConcatenate

LOAD

          DISTINCT "ref_num",

          "F_Apertura",

          "F_Resuelto",

          Grupo,

          Categoria_SLAIR,

          SLA_GRUPOS,

Date,

Start,

End

FROM

C:\Users\dnunez\Desktop\Pruebas_QV\PJ_QV_SD_Server\SLA_QVD.QVD(qvd);

AND THEN THIS IS MY TEMPORARY TABLE TMP7

TMP7:

LOAD  Distinct "ref_num",

          "F_Apertura",

          "F_Resuelto",

          Grupo,

          Categoria_SLAIR,

          SLA_GRUPOS,

Date,

Start,

End

Resident SLA

while daystart("F_Resuelto") >= daystart("F_Apertura")+iterno()-1;

LEFT join (SLA)

LOAD

Distinct "ref_num",

NUM(interval(sum(End-Start))*24) as DurationScript2

Resident TMP7 where WeekDay(Date)<5 and not match(Date,$(vHol)) group by "ref_num";

drop table TMP7;

Not applicable

Re: TABLE NO FOUND, TABLA NO ENCONTRADA

Hi,

"NoConcatenate" statement must be before TMP7 table. Also remove NoConcatenate after "SLA:" i`am not sure can it be in that place.

SLA:
LOAD....

NoConcatenate

TMP7:

LOAD...

Hope this will help.

Best,

Yani

Community Browser