topic QVd Extraction in QlikView

QVd Extraction

Fri, 18 Dec 2009 18:09:05 GMT

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.

QVd Extraction

Fri, 18 Dec 2009 18:21:13 GMT

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

QVd Extraction

Fri, 18 Dec 2009 19:11:09 GMT

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.

QVd Extraction

Fri, 18 Dec 2009 19:34:13 GMT

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