TABLE NO FOUND, TABLA NO ENCONTRADA

[#1]

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.

[sivarajs]

Your joining to a different table under TMP7 table

Make sure where you want to join

do

left join(TMP7)

[#3]

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

[#4]

try removing 'nocontenate' for table SLA

[#5]

Hi,

Try this

SLA:

LOAD .....

FROM.......

NoConcatenate

TMP7:

LOAD ......

And then join tables.

Best,

Yani

[#6]

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

[#7]

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

[#8]

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 :S please help me.

[#9]

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;

[#10]

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