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);
Can you please delete the other five discussions with the same title? They seem identical to this one. Thanks.
Hi Peter,
Sorry,
How Can i Delete other five . please tell me
Open each discussion and check the corresponding entry in the Actions Menu on the right.
Hi Peter,
I Deleted Remaining five.
Thanks
Hi Peter,
Can you Check my Script once.
Regards,
Mahesh
If you change this piece:
T2:
load
max(DATE) as DATE
Resident T1;
let INC=Peek('DATE',-1,'T2');
DROP Table T1;
into this:
T2:
Noconcatenate
load
max(DATE) as MAXDATE
Resident T1;
let INC=num(Peek('MAXDATE'));
DROP Table T1;
Then what do you get?
Best,
Peter
Hi Peter,
I am getting number format. that one also "previous of max date(second max date).
Regards
Hi,
T1:
LOAD ID,
PRODUCT,
SALES,
DATE
FROM
(qvd);
T2:
load *
Resident T1 order by DATE;
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(T3)
T4:
LOAD ID,
PRODUCT,
SALES,
DATE
FROM
(qvd) ;
STORE T3 into INC.qvd(qvd);
Hi Experts,
Can Any One Give Solution? first time not getting "max date"? where i go for reload second time i am getting "max date" in Variable