How to avoid creating a large file when a QVW file creates a QVD file?

[josephinetedesc]

Hi

I have a qvw file that daily creates 3 qvd files.

I want to keep the procedure but not the data.

I have read that I need to drop the table:

Where do i drop the table?  After each store?   Would it be better to do it after all loads?

for example:

fred:

SQL SELECT *

  FROM [directory\file];

STORE

fred INTO[fred] (qvd) ;

drop fred;

john:

SQL SELECT *

  FROM [directory\file];

STORE

john INTO[john] (qvd) ;

drop john;

Thank you

Jo

[Anil_Babu_Samineni]

I have a qvw file that daily creates 3 qvd files.

I want to keep the procedure but not the data.

I have read that I need to drop the table:

1) Where are the 3 qvd's. Here, I've seen only 2 Qvd's

2) Procedure and Keep is fine but what is the use to do store of QVD

3) Will help you, If you explain first Two

[josephinetedesc]

Hi Anil

1.     the 3rd QVD file follows the same format:

2.     I store the rows into a QVD file for use by another QVW file

3. Thanks

[jayanttibhe]

If your table structure for all 3 QVDs is exactly same then after each reload they will Auto Concatenate if you dint mention noconcatenate() function before second and 3rd Table reload.

If you are storing tables seperately, its better to drop those reloaded table after each individual table load.

[Anil_Babu_Samineni · Accepted solution]

Tested Done

Check from your end with Proper Path of stored location

Sample:

LOAD * Inline [

FiscalYear, ServiceType, Field

FY13, Type3, 13

Fy13, Type4,  25

FY14, Type3, 29

FY14, Type4, 42

FY15, Type1, 1

FY15, Type2, 5

FY15, Type3, 68

FY15, Type4, 56

];

STORE Sample into C:\Users\XXX\Downloads\Sample.qvd (qvd);

DROP Table Sample;

Sample1:

LOAD * Inline [

Name, Amount

bala, 20

bala, 10

satheesh, 15

satheesh, 15

madhu, 14

];

STORE Sample1 into C:\Users\XXX\Downloads\Sample1.qvd (qvd);

DROP Table Sample1;

Data Model Seems Empty, Now. In future, If you want to use same thing of QVD it should work

[josephinetedesc]

thank you - the syntax was

DROP Table xxx;

I did it after every individual load.

Jo