topic Re: QVD exsit or not in QlikView

QVD exsit or not

santharubban — Wed, 19 Feb 2014 20:22:31 GMT

how to check QVD exsit or not in a folder?

Re: QVD exsit or not

Gysbert_Wassenaar — Wed, 19 Feb 2014 20:27:50 GMT

if filetime('c:\mydata\my.qvd) then

//qvd exists

else

//qvd doesn't exist

end if

Re: QVD exsit or not

Clever_Anjos — Wed, 19 Feb 2014 20:28:31 GMT

If FileSize('Filename') > 0 then

trace File exists

end if

Re: QVD exsit or not

Anonymous — Wed, 19 Feb 2014 20:28:40 GMT

Hi santharubban,

in the Script, use the filetime() function to check if a file exists or not.

For ex:

if isnull(filetime('c:\filename.txt')) then

//file doesnt exists

else

//file exists

end if

Re: QVD exsit or not

chiru_thota — Wed, 19 Feb 2014 20:29:23 GMT

You can use below syntax.

LET vQvdExists = if(QvdNoOfRecords('$(QVD_Path)\$(vQvdFile)') > 0, -1, 0);

Thanks,

Chiru

Re: QVD exsit or not

santharubban — Wed, 19 Feb 2014 20:37:38 GMT

Thanks all for quick reply,

for incremental load,

v_IncrementalQVDCreatedate = QvdCreateTime('AFM.qvd');

from above, qvd exist no issues but dvd not exists it will return null.

so while loading table, i am getting error

load * from C:\Users\SXS3411\Desktop\AFM_ShadowFile.csv(txt, codepage is 1252, embedded labels, delimiter is ',', msq)where Date >$(v_IncrementalQVDCreatedate );

when IncrementalQVDCreatedate is null i am getting error. can anyone help me how to slove this.

Re: QVD exsit or not

Clever_Anjos — Wed, 19 Feb 2014 20:45:21 GMT

Use a 'default date' for example:

LET v_IncrementalQVDCreatedate = alt(QvdCreateTime('AFM.qvd'),'2001/01/01');

Re: QVD exsit or not

santharubban — Wed, 19 Feb 2014 21:16:30 GMT

while Concatenating 2 tables i am getting error

Re: QVD exsit or not

Nicole-Smith — Wed, 19 Feb 2014 21:16:54 GMT

I wouldn't use the .qvd create time for your incremental load. If you're pulling data from a very large file, the file could take minutes to import and store into a .qvd. If new records were added in those few minutes, you'll miss those by using the .qvd create time. I would suggest using a max date field from within the field itself.

Re: QVD exsit or not

Clever_Anjos — Thu, 20 Feb 2014 12:09:06 GMT

Could you post your script? I´ll check it