Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to update a QVD file?

Hi Everyone,

Please help me regarding updating QVD file.

Potential:

LOAD Number

FROM

potential.xlsx

(ooxml, embedded labels, table is Sheet1)

where not exists(Number);

Concatenate

load Number from Potential.qvd(qvd)

where not Exists(Number);

store Potential into C:\Documents and Settings\sachin.GALAXYHO\Desktop\samples\Potential.qvd;

I have changed a value in Numer column ie i have updated value 1 to 11111 in number column in my excel file.
Now when i use above code then it gives me error"execution failed"

please tell me how do i update my QVD file?

10 Replies
Not applicable
Author

File that you loading from and storing to might be not the same.

Not applicable
Author

Hi,

Pls change path C:\Documents and Settings\sachin GALAXYHO\Desktop\samples\Potential.qvd;

instead of

store Potential into C:\Documents and Settings\sachin.GALAXYHO\Desktop\samples\Potential.qvd;

Dont put " . " in folder name .

Hope it will help u

regards-bika

Not applicable
Author

Hi Bika,

It is not working,
It is a path which is directly coming after loading table from the potential excel file.

regards-hitesh

er_mohit
Master II
Master II

see the attached file

simply you try to change the path E:\ update.qvd;

then see the result where you wrong

Anonymous
Not applicable
Author

HI,

If you want to update your QVD, then you have to load it first.

In your example, the script will be:

Potential:

LOAD

      Number

FROM

     Potential.qvd(qvd)

;

LOAD

     Number

FROM

     potential.xlsx

(ooxml, embedded labels, table is Sheet1)

Where

     not exists (Number,Number);

store Potential into C:\Documents and Settings\sachin.GALAXYHO\Desktop\samples\Potential.qvd;

Not applicable
Author

Hi Mohit,

I am using personal edition so plz copy the code in word file and attach.

thanks and regards,

Hittesh.

Not applicable
Author

TRY ACCORDING TO THIS--

POTENTIAL_QVD:

LOAD * INLINE [

    id,name

    1, dddk

    2,cck

];

join

POTENTIAL_EXCEL:

LOAD * INLINE [

    id,name

    1, dk

    2,cck

    3,ab

    4,cd

]Where not Exists(id);

STORE   POTENTIAL_QVD into D:\POTENTIAL_QVD

*****************************************************************************

or try this

POTENTIAL_QVD_test:

LOAD * INLINE [

    id_test,name_test

    1, dddk

    2,cck

];

Right Join

POTENTIAL_EXCEL_test:

LOAD * INLINE [

    id_test,name_test

    1, dk

    2,cck

    3,ab

    4,cd

];

STORE   POTENTIAL_QVD into D:\POTENTIAL_QVD

er_mohit
Master II
Master II

sorry for late reply

script is

a:

LOAD product_id ,

     p_value

FROM

(ooxml, embedded labels, table is Sheet1);

Concatenate (a)

LOAD product_id ,

     p_value

FROM

(ooxml, embedded labels, table is Sheet2)

Where not Exists (product_id);

STORE a into E:\Update.qvd;

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     One reason could be, you dont have the right to write into file.

     Kindly look into the windows file security.

     Also try deleting the QVD and regenerate it with diff name.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!