topic Re: File Exists in QlikView

File Exists

Wed, 07 Sep 2016 12:52:05 GMT

Hello All,

I have tried to create a loop to load files, it works except for the part where its supposed to identify if the file exists and just carry on if it doesn't...can anyone help please.

let vSYear=2016;

let vSMonth=6;

let vSPe=$(vSYear)&

if($(vSMonth)<10,'-0','-')

&$(vSMonth);

let vEYear=year(now());

let vEMonth=num(month(now()),'0');

let vEPe=$(vEYear)&

if($(vEMonth)<10,'-0','-')

&$(vEMonth);

set a='$(vSPe)';

Do While a<'$(vEPe)'

Let vDs=1;

Do While vDs<=31

let vDss=if($(vDs)<10,'-0','-')

&$(vDs);

SET vFileName1='';

LET $(vFileExsist1)=isnull(QvdCreateTime('$(vFileName1)'));

//Let vFileExsist=if(FileSize($(vFileName))>0,-1,0);

SET vFileName2='';

Let $(vFileExsist2)=isnull(QvdCreateTime('$(vFileName2)'));

//Let vFileExsist=if(FileSize($(vFileName))>0,-1,0);

if $(vFileExsist1)=0 then

t_tmp:

LOAD DateTime as StartDate,

ClientIdNo,

[Age Group],

Amount,

TxId,

Product

FROM

(qvd);

End if

if $(vFileExsist2)=0 then

Concatenate (t_tmp)

LOAD DateTime as StartDate,

ClientIdNo,

[Age Group],

Amount,

TxId,

Product

FROM

(qvd);

End if

let vDs=$(vDs)+1;

loop

Re: File Exists

kristof_j — Wed, 07 Sep 2016 13:01:12 GMT

And if you don't create a variable and you write this before "t_tmp:"

IF not IsNull(FileSize('$(vFileName1)')) then ...

Re: File Exists

jonathandienst — Wed, 07 Sep 2016 13:15:20 GMT

This line:

>>LET $(vFileExsist1)=isnull(QvdCreateTime('$(vFileName1)'));

Should read:

LET vFileExsist1 = Not(isnull(QvdCreateTime('$(vFileName1)')));

Similarly

>> Let $(vFileExsist2)=isnull(QvdCreateTime('$(vFileName2)'));

Should read:

LET vFileExsist2 = Not(IsNull(QvdCreateTime('$(vFileName2)')));

(make sure that you use consistent spelling of the varables..)

Re: File Exists

Wed, 07 Sep 2016 13:47:03 GMT

ok, but the problem is that there are 2 if statements, and it has issues with the fact that i am not ending them, have tried 'EndIf' and 'End if'

Thanks for the help will try and see anyways

Re: File Exists

Wed, 07 Sep 2016 13:48:39 GMT

Awesomeness, this works...thanks