Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have some qvd's are deleted how to identify in qlikview, Is there any method or function to find out
deleted qvd's
Thanks,
Tejeswara Rao.
I am not sure what you require. How would you identify something that has been deleted?
In my environment my qvw associate some qvd tables which are deleted,How do you check
like manual method or any function available in qlikview
Are you wanting to check whether the qvd file exists before processing it? If so, use the FILESIZE() function:
IF ISNULL(FILESIZE('<path to qvd file>')) > -1 THEN
<code to process qvd file>
END IF
Sorry, the ISNULL() should be <> -1 (not > -1)
Thanks Kevin..
In Qlik Deployment framework there is a built in function to validate content:
vL.FileExist sub function validates if a file or folder exists, can be used before load to avoid errors during script load.
Syntax example in the script: call vL.FileExist('$(vG.QVDPath)\*');
Variable vL.FileExist returns true or false.
Example, action exit script after check:
call vL.FileExist ('$(vL.MetaDataQVDPath)\1.NorthWind);
Will Check if1.NorthWind folder exists and return vL.FileExist = true or false
call vL.FileExist ('$(vL.MetaDataQVDPath)\SOE.qvd');
if vL.FileExist = 'false' then; trace '### Did not find file, exit script'; exit script; endif;