Optimized Load

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

How can i keep the Optimized load,When loading the table "log" ?

Please see below Script.

LeadsTest:

LOAD * INLINE [Leads_Uniquetest,Name

69];

NoConcatenate

logNew:

LOAD * INLINE [ID,Leads_Unique,Name,colur

5,67,test1,testcolur1

6,68,test2,testcolur2

];

Concatenate

log:

LOAD ID ,Leads_Unique,Name,colur

from (qvd)

where Exists (Leads_Uniquetest,Leads_Unique)

and not Exists (IDtest,ID);

drop table LeadsTest;

------------------------------------------------------------------

QVD Contains:

log:

LOAD * INLINE [ID ,Leads_Unique,Name,colur

5,67,test1,testcolur1

6,68,test2,testcolur2

7,69,test3,testcolur3

];

Thanks!

Re: Optimized Load

marcus_sommer — Thu, 12 Jan 2017 15:21:58 GMT

You need to use the exists-function with only one parameter like:

LeadsTest:

LOAD * INLINE [Leads_Unique,Name

69];

NoConcatenate

logNew:

LOAD * INLINE [ID,Leads_Unique,Name,colur

5,67,test1,testcolur1

6,68,test2,testcolur2

];

Concatenate

log:

LOAD ID ,Leads_Unique,Name,colur

from (qvd)

where Exists (Leads_Unique);

//and not Exists (IDtest,ID);

drop table LeadsTest;

For this you might need some changes to the load of Leads_Unique and the field ID which might be combined with Leads_Unique or you might need to split your logic into several loadings then only with a single exists() will be a load optimized. Within the last link-block of this document: Advanced topics for creating a qlik datamodel you will find various examples of this topic.

- Marcus

topic Re: Optimized Load in QlikView

Optimized Load

Re: Optimized Load