how to extract data from qvd into existing qvw

[#1]

hi

i am loading qvd in qvw

.

.

.

load * from CLR.qvd (qvd);

but when i go to dashboard sheet and right clik on properties, i do nto see CLR in tables options?

please advise

thanks

[kaushiknsolanki]

Hi,

     It is because you need to rename the table.

     something like this.

     CLR:

     load * from CLR.qvd (qvd);

     Also make sure that QVD has atleast 1 record.

Regards,

Kaushik Solanki

[#3]

the below script i wrote:

EURT:

Load

.

.

.

.

From

File

Store EURT into CLR.qvd(qvd);

CLREUR:

load * from CLR.qvd(qvd);

Still i am not able to see CLREUR as a table in dashboard under Properties.

please adivse

thanks

[Anonymous]

Hi,

You try opening QVD directly into a QVW( qlikiview application) so that you will be able to check whether data is there or not. Once you are sure that all the data is there in that qvw apps(after reload).

step two:

Again you try opening qvd in your application using Data from file option -> select table files and then desired QVD.

Then put some table name ex :-

Table:

Field 1,

Field 2,

------

From ------ (qvd). -> Save and reload. lets do this exercise and let us know are you still not able to see the table.

May be you will have to check script throughly else where have you mentioned drop table statement by mistake?

Best,

SKumar

[kaushiknsolanki · Accepted solution]

Hi,

     The reason is the EURT table has the same numbers of fields as well as same field name which CLREUR table has and thus by default QlikView is concatenating both the tables.

     Try this.

EURT:

Load

.

.

.

.

From

File

Store EURT into CLR.qvd(qvd);

Drop table EURT;

CLREUR:

load * from CLR.qvd(qvd);

Regards,

Kaushik Solanki

[#6]

you are the boss.

its working now

thanks