Create QVD in my desktop

[Anonymous]

HI

i am trying to create qliksense QVD in my local desktop

i am trying as

tablename:

Load * from table1;

store tablename into tablename.qvd // got error

Also tried as below , got error again. Can some one help

tablename:

Load * from table1;

store tablename into C:/QVD/tablename.qvd // got error

[Chanty4u]

concatenate two qvds and store into one that will be main qvd.

load *,

a,

b,........ from qvd1;

concatenate

load *,

d,

e

.... from qvd2;

store into  MainTable into lib://QVD/QVD/MainTable.qvd;

[agigliotti · Accepted solution]

you can do as below:

STORE table1 into [lib://QVD/table1.QVD] (qvd);

STORE table2 into [lib://QVD/table2.QVD] (qvd);

table3:

noconcatenate

load * resident table1;

concatenate

load * resident table2;

STORE table3 into [lib://QVD/table3.QVD] (qvd);

[Anonymous]

Thankyou, it works

one more thing if i need to give some filter on a column data, how can i do it.

Select * from Tablename.qvd where column1='10';

this is throwing error for me

[agigliotti]

you should apply it in load statement.