Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have one small doubt in Qlikview Error handling.
I am transfering QVDs with the help of FTP from server to the local machine. Due to Connectivity issue , some qvds are partially transfered.
I have 10 QVDs in my load script . From these , two qvds are partially transfered.
I have set errormode =0; to skip the corrupted qvds and move to the next statement. Kindly sort my issue.
My Load Script:
Set ErrorMode=0;
SALES:
Load *
From SALES_*.qvd(qvd);
Regards,
Siva
My ErrorMode doesnt works in this case.
Regards,
Siva
Maybe you could detect the corrupted qvd inside your error-handling with a file-functions like filetime() or filesize() or qvdnoofrecords(). If not then you need a way to compare such things like the filesize from server and local - maybe if you creates an additionally check-table with these informations in txt-fileformat or similar.
- Marcus