Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How can i keep the Optimized load,When loading the table "log" ?
Please see below Script.
LeadsTest:
LOAD * INLINE [Leads_Uniquetest,Name
67
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
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!
You need to use the exists-function with only one parameter like:
LeadsTest:
LOAD * INLINE [Leads_Unique,Name
67
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
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