topic Re: loading qvd? in QlikView

loading qvd?

Anonymous — Mon, 29 Sep 2014 11:07:51 GMT

Here i have a qvd up to Aug month(creating monthly qvds) but i dont know whether qvd is avaliable for Sep month

here i want write expression for like

load all qvds and if Sep qvd is avaliable then load otherwise leave it?

Re: loading qvd?

sushil353 — Mon, 29 Sep 2014 11:34:43 GMT

Hi,

you can simply write:

Set Errormode = 0 ;

in your script.. it will ignor error if script will not find sep qvd.

HTH

Sushil

Re: loading qvd?

Anonymous — Mon, 29 Sep 2014 11:36:24 GMT

pls tell me how to write script for this load qvds

Re: loading qvd?

maxgro — Mon, 29 Sep 2014 11:38:27 GMT

if (FileSize('201409.qvd')>0) then

trace load;

LOAD *

FROM 201409.qvd (qvd);

ELSE

trace skip;

end if;

Re: loading qvd?

sushil353 — Mon, 29 Sep 2014 11:42:20 GMT

you need to write for loop for this:

first of all get the values of each month in a table say monthtable

then say want to load data for 12 months

SET Errormode = 0;

for i=0 to 11

LET monthtable= peek('Month',$(i),'monthtable')

load

from Table_$(monthtable).qvd(qvd);

HTH

Sushil

Re: loading qvd?

fkeuroglian — Mon, 29 Sep 2014 12:06:30 GMT

Hi, see this hope helps

IF (isNull(qvdCreateTime('../2_QVD/201409.qvd'))) THEN

LOAD *

FROM 201409.qvd (qvd);

ELSE

Let MiMensaje = '1' & ' ERROR' & ' 201409.qvd' ;

trace $(MiMensaje);

END IF;

Re: loading qvd?

shane_spencer — Mon, 29 Sep 2014 12:07:59 GMT

Can't you simply use * to load all QVD's that are present in the directory rather than naming them specifically? If September is there it will be load, if it isn't obviously it won't.

Re: loading qvd?

ppmc — Mon, 29 Sep 2014 12:12:56 GMT

hy, try this:

for Each file in FileList ('Your Directory\*.qvd')

Temp:

load

from $(file) (qvd) ;

next file;

best regards