Need for erasing QVD s?

Anonymous — Tue, 08 Jan 2013 14:19:45 GMT

Hello,

I've just finished my first loading script. Yabadibaduu!

But Im not sure whether its nicely programmed as I'm all the time storing and loading qvd s which I don't need in the end anymore.

Im not sure whether I should just delete the qvd s via DOS (cmd command) at the end OR whether I should the whole time use resident tables and after avery process step the earlies tables...

Maybe someone can show me how the design should look like.

Here are three of my tabs (I proceed like that for 10 further tabs) - Thanks for your help! :

---------------------------------TAB1--------------------------------
TOL_NEW:

LOAD lTolRef,
     lTolTypRef,
     sDepot,
     sDescript,
     sName
FROM
..\..\02_Data\TOL_MI.qvd
(qvd)
Where ( (lTolTypRef = 10) OR (lTolTypRef = 20) OR (lTolTypRef = 30) )
;

Left Join

LOAD
lTolRef,
lJobRef

FROM
..\..\02_Data\TOL_BOK_MI.qvd
(qvd);

Store TOL_NEW into ..\..\02_Data\TOL_New_MI.qvd;

let numTables = NoOfTables();
for i=1 to $(numTables)
let tt = TableNAme(0);
drop table [$(tt)];
next

---------------------------------TAB2--------------------------------
JOB_NEW:

LOAD dSetQuant,
     dSetShots,
     dSetSpeed,
     iActCavity,
     iSetCavity,
     lJobRef,
     sName as Auftragsnummer,
     sType,
     tActBegin,
     tActEnd,
     tReleaseDate

FROM
..\..\02_Data\JOB_MI.qvd
(qvd);

Left Join

LOAd

lTolRef as lTolRefArt,
     sDescript as Artikelbeschreibung,
     sName as Artikel,
     lJobRef


From ..\..\02_Data\TOL_New_MI.qvd
(qvd)
Where ((lTolTypRef = 10))
;

Store JOB_NEW into ..\..\02_Data\JOB_10b1_MI.qvd;

let numTables = NoOfTables();
for i=1 to $(numTables)
let tt = TableNAme(0);
drop table [$(tt)];
next

---------------------------------TAB3--------------------------------
JOB_NEW:

LOAD dSetQuant,
     dSetShots,
     dSetSpeed,
     iActCavity,
     iSetCavity,
     lJobRef,
     Auftragsnummer,
     sType,
     tActBegin,
     tActEnd,
     tReleaseDate,
     lTolRefArt,
     Artikelbeschreibung,
     Artikel

FROM
..\..\02_Data\JOB_10b1_MI.qvd
(qvd);

Left Join

LOAd

sDepot as Werkzeuglagerort,
     sDescript as Werkzeugbeschreibung,
     sName as Werkzeug,
     lJobRef
     //bZusatz

From ..\..\02_Data\TOL_New_MI.qvd
(qvd)
Where ((lTolTypRef = 20))
;

Store JOB_NEW into ..\..\02_Data\JOB_10b1_20_MI.qvd;

let numTables = NoOfTables();
for i=1 to $(numTables)
let tt = TableNAme(0);
drop table [$(tt)];
next

Re: Need for erasing QVD s?

adamwilson — Tue, 08 Jan 2013 14:43:22 GMT

I would keep the tables in Resident and only store the Tables you plan to use later in QVDs, there is no other reason to store them in QVDs if they are already loaded in the QVW and you are not using them later.

Re: Need for erasing QVD s?

Anonymous — Tue, 08 Jan 2013 14:51:28 GMT

Can you please show me how you would do it with these 3 tabs.

Thank you

Re: Need for erasing QVD s?

adamwilson — Tue, 08 Jan 2013 15:13:14 GMT

it's hard to show you an appropriate example without knowing what you are wanting to achieve, however I generally will load a tables into resident and keep it there if I am using it multiple times in the script and then drop it when I am finished with it rather then loading it and dropping it multiple times.

topic Re: Need for erasing QVD s? in QlikView

Need for erasing QVD s?

Re: Need for erasing QVD s?

Re: Need for erasing QVD s?

Re: Need for erasing QVD s?