Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to extract data from qvd into existing qvw

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

1 Solution

Accepted Solutions
kaushiknsolanki

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

5 Replies
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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Not applicable
Author

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

shubham_kumar
Creator III
Creator III

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

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

Not applicable
Author

you are the boss.

its working now

thanks