Preparation / Loading of Data - General approach

Anonymous — Wed, 07 Nov 2012 14:05:46 GMT

Hello QlikCommunity

I don't know what is the right way to load and cleanse the data.

What I did first is to load the data 1:1 and store it in qvd s.

Then I load the qvd s and join, cleanse .. the data.

Here is some code to show what i mean:

-------------------------------------------------------------------------------------CODE-----------------------------------------------------------------------------

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

Left Join
LOAD
      lTolRef,
      lJobRef//      ,
//     lTolTypRef,
//      tBeginFROM
..\..\02_Data\TOL_BOK_MI.qvd
(qvd);

Store

TOL_NEW into

..\..\02_Data\TOL_New_MI.qvd;

Redister 2:

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,
     lTolTypRef,
     sDepot,
     sDescript,
     sName as TOL_sName,
     lJobRef

From ..\..\02_Data\TOL_New_MI.qvd
(qvd);

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

LOAD dSetQuant,
     dSetShots,
     dSetSpeed,
     iActCavity,
     iSetCavity,
     lJobRef,
     Auftragsnummer,
     sType,
     tActBegin,
     tActEnd,
     tReleaseDate,
     lTolRef,
     lTolTypRef,
     sDepot,
     sDescript,
     TOL_sName
FROM
..\..\02_Data\JOB_NEW_MI.qvd
(qvd);

-------------------------------------------------------------------------------------CODE-----------------------------------------------------------------------------

1. Do I have to save my loaded data into qvd s in order to work wiith them later on?

2. I dont really know how to drop the Tables

//Drop Table TOL_NEW;

was not working on register nr 1

so I was always using the script :

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

3) Am I on the right way or are there some bigger mistakes in my procedure??

Thanks in advance!

chesterluck

Re: Preparation / Loading of Data - General approach

Gysbert_Wassenaar — Wed, 07 Nov 2012 14:23:27 GMT

1. No, it's not necessary, but it can be a good idea as a store and load to and from a qvd may be faster than using a resident table.

2. Drop Table TOL_NEW; is the correct syntax. So that should work as long as you keep case sensitivity in mind.

3. Looks ok to me as far as I can tell.

topic Re: Preparation / Loading of Data - General approach in QlikView

Preparation / Loading of Data - General approach

Re: Preparation / Loading of Data - General approach