QVD Creation

[#1]

Hi All,

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

SRS

[christophebrault]

Hi,

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

STORE YourTable into YourQVDName.QVD;

[#3]

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

[janardhan]

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

[nilesh_gangurde]

Hi Sanjay,

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

Regards,

Nilesh Gangurde

[#6]

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

[nilesh_gangurde]

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

[janardhan]

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;

[#9]

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

[nilesh_gangurde]

Table1:

load * from

D1;

store Table1 into Table1.qvd;

Table2:

load * from

D1;

store Table2 into Table2.qvd;

Add colon at the smily.