Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QVd Extraction

I am extracting the data from SAP sometimes connection get lost and i have lost my existimg qvd and it shows me the size of existing qvd to 3 KB that was showing 189 MB so i want the code through which i can replace the existing qvd if extracted successfully without any error else the existing qvd 's remain same.

menas if Extarction = sucess then

replace the exsting qvd

else

The last file remains same with no modification.

and the same time i get the indication that my this tables had not picked the data becasue of some error in some text or excel file.

3 Replies
Not applicable
Author

Hi,

try this example:

If ScriptError = 0 Then

Execute cmd /c move /y Dax.qvd Dax_Old.qvd;

Store Dax into Dax.qvd;

End If

Good luck!

Rainer

Not applicable
Author

See i have Existing qvd, On daily daily baisis i m picking the Incremental load and append that new data into existing qvd's file . and for that i have one one folder where all live qvd exists and

i picked the daily data prepared key on that data and concatente that with existing data and after that store/Replace that exiting qvd file with new prepard file ..

now i want if the t=extraction get success then only it replace/Store else

exit the file.

Not applicable
Author

Hi,

that is what it stands for.

A new qvd file will only be written if noe error occurred.

Another way could be exit script if an error occurred.

For more details see QV help: ScriptError and you will find an example.

Good luck!

Rainer