topic Re: How to avoid creating a large file when a QVW file creates a QVD file? in QlikView

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

josephinetedesc — Fri, 10 Feb 2017 01:25:49 GMT

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

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

Anil_Babu_Samineni — Fri, 10 Feb 2017 01:43:18 GMT

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

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

josephinetedesc — Fri, 10 Feb 2017 02:29:32 GMT

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

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

jayanttibhe — Fri, 10 Feb 2017 02:35:10 GMT

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.

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

Anil_Babu_Samineni — Fri, 10 Feb 2017 02:38:46 GMT

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

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

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

josephinetedesc — Fri, 10 Feb 2017 03:34:44 GMT

thank you - the syntax was

DROP Table xxx;

I did it after every individual load.