topic QVD store in QlikView

QVD store

vijetas42 — Wed, 25 Jul 2018 09:11:16 GMT

Hi,

I have one database table where no. of rows are 223 million.in that I have 3 fields ID,class_nbr and roll_nbr

in this case i want to create two different qvd's with hitting db table only once.in first qvd it will store ID and class_nbr and in second ID and roll_nbr.

how to achieve this

Re: QVD store

YoussefBelloum — Wed, 25 Jul 2018 09:16:16 GMT

Hi,

just load ID and Class nbr on the first load followed by a STORE

then load ID and roll nbr on a second table followed by a second STORE

Re: QVD store

atoz1158 — Wed, 25 Jul 2018 09:50:42 GMT

Assuming that the the load was into a table called "mytable" then use the following two store statements adjusting of course for your own names

STORE ID, class_nbr from mytable into firstqvd.qvd (qvd);

STORE ID, roll_nbr from mytable into secondqvbd.qvd (qvd);

Regards

Adrian

Re: QVD store

BalaBhaskar_Qlik — Wed, 25 Jul 2018 13:10:31 GMT

Connection string....

Table1:

Load

[Store ID],

Class_nbr; or (Load *;)

SQL

Select

[Store ID],

Class_nbr from Table; (Add conditions if required)

Store Table1 into Path\Table1.qvd(QVD);

NoConcatenate

Table2:

Load

[Store ID],

roll_nbr; or (Load *;)

SQL

Select

[Store ID],

roll_nbr from Table;

Store Table2 into Path\Table2.qvd(QVD);