Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
try to put $(FilePath) with out quotes in for statement
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?
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.
I think is more the asterisk rather than the loop, or they may be both.
first 1 LOAD
FechaFoto
FROM
(
it's a big difference having 68 records from having 20 million records.
Iill go around. %$#&