topic Script NOT Working in QlikView

Script NOT Working

christian77 — Wed, 03 Dec 2014 09:03:27 GMT

Hi: I have this script below. I'm trying to get the QVD with the maximun date. When in a loop, the clause first 1 load DOES NOT WORK, making the script last long. It does work in the second table, out of the loop. I've already try with FileName and FileTime and it is even slower.

Any suggestion?

What am I doing wrong? Why it has to read the whole table when it says clearly first 1 load?

QlikView is a good application but when you put 2 functions together it stops being good. Why?

FilePath='\\PATH\QV.Source\99.Shared_Folders\2.QVD\NM_249_QVDS\NM_249_*_*.qvd';
for each File in filelist ('$(FilePath)')
/////trace $(File);
QVDSAVAILABLES:
first 1 load
FechaFoto
from $(File) (qvd);
next File;
MAXQVD:
LOAD
MaxString(FechaFoto) as FechaFoto2
resident QVDSAVAILABLES
group by 1;
drop table QVDSAVAILABLES;
let Fecha249 = DATE(peek('FechaFoto2',0,'MAXQVD'),'YYYYMMDD');
trace $(Fecha249);
drop table MAXQVD;
SNP_249:
first 1 LOAD NumContrato,
//CodEntidad,
FlagFoto_InicioMes,

Field1,

Fieldn

FROM
[$(vG.QVDPath)\NM_249_QVDS\NM_249_$(Fecha249)_*.qvd]
(qvd);

Re: Script NOT Working

sushil353 — Wed, 03 Dec 2014 09:10:38 GMT

try to put $(FilePath) with out quotes in for statement

Re: Script NOT Working

tresB — Wed, 03 Dec 2014 09:14:30 GMT

It is possibly taking long time because it is fetching data from network path. And might be the number of qvds is not very small as well, right?

Re: Script NOT Working

christian77 — Wed, 03 Dec 2014 09:31:50 GMT

Nope. it does not. Thanks anyway.

Thanks. 68 files.

The point here is that first 1 load does not work inside the loop.

I can't reply individualy.

Re: Script NOT Working

christian77 — Wed, 03 Dec 2014 11:32:39 GMT

I think is more the asterisk rather than the loop, or they may be both.

first 1 LOAD
FechaFoto
FROM

(qvd);

it's a big difference having 68 records from having 20 million records.

Iill go around. %$#&