topic Re: QVD Creation in QlikView

QVD Creation

Wed, 16 May 2012 11:50:53 GMT

Hi All,

How to create QVD files, Different ways to create a QVD

SRS

QVD Creation

christophebrault — Wed, 16 May 2012 11:52:31 GMT

Hi,

After your load statement, you can simply write this code to store a table in a QVD :

STORE YourTable into YourQVDName.QVD;

QVD Creation

Wed, 16 May 2012 11:58:24 GMT

Hi,

Thanks but when i put store statement after the load of the table it works for first table but when creating store statement for the second table it will not creating qvd, is there any other way to create a QVD.

SRS

QVD Creation

janardhan — Wed, 16 May 2012 12:08:36 GMT

Hi Sanjay,

u need to create another tab and place the second table and write the store statement there it will work

for ur convinence or easy to identify tables u need to create new tabs.

Regards

jana

Re: QVD Creation

nilesh_gangurde — Wed, 16 May 2012 12:13:20 GMT

Hi Sanjay,

Check out that you are not using the Same qvd Names for store statement of two different tables.

Regards,

Nilesh Gangurde

QVD Creation

Wed, 16 May 2012 12:41:27 GMT

Hi All,

Thanks to you all my situation is that i load data from the 5 excel files and the excel file contains same fields and there is one sheet its name is also same when i create a qvd of first table it create with its name but not for second.

Can i rename this 5 excel files my motive is that i load this excel files and create QVD of this excel files but the sheet name, fields in the excel is same.

SRS

QVD Creation

nilesh_gangurde — Wed, 16 May 2012 12:45:31 GMT

Hi sanjay ,

write your script as follows:

tablename1:

load * from

excel1;

store tablename1 into tablename1.qvd;

tablename2

load *

from excel2;

store tablename2 into tablename2.qvd;

Do it for all the excel and you will get the 5 qvd's

Regards,

Nilesh Gangurde

QVD Creation

janardhan — Wed, 16 May 2012 12:50:55 GMT

Hi Sanjay ,

Nilesh is correct but he missed one thing

tablename1:

load * from

excel1;

store tablename1 into tablename1.qvd;

tablename2:

load *

from excel2;

store tablename2 into tablename2.qvd;

Re: QVD Creation

Wed, 16 May 2012 13:03:30 GMT

Hi,

My script is like

Table1:

load * from

D1;

store Table1 into Table1.qvd;

Table2:

load * from

D1;

store Table2 into Table2.qvd;

D1 is a sheet name which is from different excel files with same sheet name

but wont work for me.

SRS

QVD Creation

nilesh_gangurde — Wed, 16 May 2012 13:06:10 GMT

Table1:

load * from

D1;

store Table1 into Table1.qvd;

Table2:

load * from

D1;

store Table2 into Table2.qvd;

Add colon at the smily.

Re: QVD Creation

Wed, 16 May 2012 13:12:09 GMT

Hi,

I use semicolon there but not work.

SRS

Re: QVD Creation

janardhan — Wed, 16 May 2012 13:20:29 GMT

Save it first and do reload it will work

Re: QVD Creation

Wed, 16 May 2012 13:23:05 GMT

Hi,

I save it and reload it but not work my scrpt is this

Table1:

load * from

D1;

store Table1 into Table1.qvd;

Table2:

load * from

D1;

store Table2 into Table2.qvd;

SRS

Re: QVD Creation

janardhan — Wed, 16 May 2012 13:28:13 GMT

try like this

Table1:

load * from

D1;

store Table1 into Table1.qvd;

drop table Table1;

Table2:

load * from

D1;

store Table2 into Table2.qvd;

drop table Table2;

Re: QVD Creation

its_anandrjs — Wed, 16 May 2012 13:37:58 GMT

Hi,

Use some thing like this in the script

Table1:

load * from

D1;

store Table1 into Table1.qvd;

Table2:

NoConcatenate

load * from

D1;

store Table2 into Table2.qvd;

Regards,

Anand

QVD Creation

nilesh_gangurde — Wed, 16 May 2012 20:20:06 GMT

Hi sanjay,

Attach a sample qvw file.

Regards,

Nilesh Gangurde

Re: QVD Creation

Sokkorn — Thu, 17 May 2012 02:44:24 GMT

Hi,

I try your script and working for me. Let see in the attached files.

Edit: Put all files in the same folder.

Regards,

Sokkorn

Re: QVD Creation

Thu, 17 May 2012 05:39:48 GMT

Hi,

But it create synthetic keys.

SRS

Re: QVD Creation

its_anandrjs — Thu, 17 May 2012 05:44:21 GMT

Hi,

If you not need the loaded tables so delete it and use the QVD files.

Regards,

Anand

QVD Creation

rotero — Fri, 18 May 2012 03:35:39 GMT

may i ask... is there an effect of you issue drop table after the store statement?

and also what is nonconcaatenate use for?