Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
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
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
you are the boss.
its working now
thanks