Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Is there any Mistake? I am getting " MAXDATE" in table. not getting in VARIABLE"
T1:
LOAD ID,
PRODUCT,
SALES,
DATE
FROM
(qvd);
T2:
load
max(DATE) as DATE
Resident T1;
let INC=Peek('DATE',-1,'T2');
DROP Table T1;
T3:
LOAD ID,
PRODUCT,
SALES,
DATE
FROM
(ooxml, embedded labels, table is Sheet2) Where DATE>$(INC);
Concatenate
T4:
LOAD ID,
PRODUCT,
SALES,
DATE
FROM
(qvd) where not exists (ID);
STORE T3 into INC.qvd(qvd);
Inner Join
T5:
LOAD ID
FROM
(ooxml, embedded labels, table is Sheet2) ;
STORE T3 into INC.qvd(qvd);
Hi Experts,
I got the output.if i create the same Variable in end of the script i am getting max date.(Variable overrided)
Thanks for your support
Regards,
Mahesh