Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
am using autonumber function to save the memory
am not sure at this situation it will be helpful.
Can someone help me out in this please??
test1:
LOAD
C_CODE,
E_CODE,
SP_CODE,
G_CODE,
P_REPORT_TO,
DOJ,
GR_CODE,
SEC_CODE,
OFF_CODE,
DH_DATE,
AutoNumber(Text(Trim(C_CODE))&'-'&Text(Trim(E_CODE))&'-'&Text(Trim(SP_CODE))&'-'&Text(Trim(G_CODE))&'-'&Text(Trim(P_REPORT_TO))&'-'&Num(Floor(DOJ))
&'-'&Text(Trim(GR_CODE))&'-'&Text(Trim(SEC_CODE))&'-'&Text(Trim(OFF_CODE))) as Key
FROM<>qvd;
Noconcatenate
test2:
Today:
LOAD
C_CODE,
E_CODE,
//SP_CODE,
G_CODE,
P_REPORT_TO,
DOJ,
GR_CODE,
//SEC_CODE,
OFF_CODE,
DH_DATE
FROM<>(qvd)
Where not Exists
(Key,AutoNumber(Text(Trim(C_CODE))&'-'&Text(Trim(E_CODE))&'-'&Text(Trim(SP_CODE))&'-'&Text(Trim(G_CODE))&'-'&Text(Trim(P_REPORT_TO))&'-'&Num(Floor(DOJ))
&'-'&Text(Trim(GR_CODE))&'-'&Text(Trim(SEC_CODE))&'-'&Text(Trim(OFF_CODE)))) and Num(Floor(DOJ))<>Num(Floor(Today()-1));
This might be helpful when optimizing: Tools | Qlikview Cookbook