topic Re: How to update a QVD file? in QlikView

How to update a QVD file?

Thu, 27 Jun 2013 11:38:45 GMT

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?

Re: How to update a QVD file?

Thu, 27 Jun 2013 11:46:17 GMT

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

Re: How to update a QVD file?

Thu, 27 Jun 2013 11:52:57 GMT

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

Re: How to update a QVD file?

Thu, 27 Jun 2013 12:06:53 GMT

Hi Bika,

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

regards-hitesh

Re: How to update a QVD file?

er_mohit — Thu, 27 Jun 2013 12:53:19 GMT

see the attached file

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

then see the result where you wrong

Re: How to update a QVD file?

Anonymous — Thu, 27 Jun 2013 13:26:12 GMT

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;

Re: How to update a QVD file?

Fri, 28 Jun 2013 05:11:26 GMT

Hi Mohit,

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

thanks and regards,

Hittesh.

Re: How to update a QVD file?

Fri, 28 Jun 2013 06:05:25 GMT

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

Re: How to update a QVD file?

er_mohit — Mon, 01 Jul 2013 13:41:52 GMT

sorry for late reply

script is

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;

Re: How to update a QVD file?

kaushiknsolanki — Mon, 01 Jul 2013 13:44:57 GMT

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

Re: How to update a QVD file?

Tue, 02 Jul 2013 05:30:20 GMT

Hi mohit i have tried with your sol but still it is not working.

see i have qvd file having one column 'Number' which has ' 1,2,3,------10' field no...

now i have updated my excel file ... i changed 1 to 11111....

i am using foll script as per your sol...

LOAD Number

FROM

potential.xlsx

(ooxml, embedded labels, table is Sheet1);

concatenate(a)

LOAD Number From Potential.qvd(qvd)

where not Exists(Number);

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

but using this it is concatenating both...

i get a list "1,2,3,---------,10,11111"

where it is not droping the qvd content...