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));
