Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys,
Please support with the question in touch with Last Value.
I have bellow data in the script:
CDHDR_FINAL:
Load *,
If(TCODE='ZKIT_PO01' or TCODE='ZTCS',AEDAT_CDHDR,UDATE) as PO_Appr.Date_TMP
Resident CDHDR;
Drop Table CDHDR;
LastValue:
LOAD CDHDR_KEY,
LastValue(PO_Appr.Date_TMP) as Last_PO_Apprv_Date,
LastValue(USERNAME) as Last_PO_Approver
Resident CDHDR_FINAL
Group By CDHDR_KEY;
In visualization almost everything is okay, but for some raw this rule doesn't work correctly.
For example I should have as "Last_PO_Apprv_Date" 21.09.2018, but it shows only 17.09.2018, which is first, not last, date in the list of changes.
Please support and thanks in advance.
Hi Ivan. Not sure, but maybe an ordering will help
LOAD CDHDR_KEY,
LastValue(PO_Appr.Date_TMP) as Last_PO_Apprv_Date,
LastValue(USERNAME) as Last_PO_Approver
Resident CDHDR_FINAL
Group By CDHDR_KEY
Order by USERNAME, PO_Appr.Date_TMP;
Hi Ivan,
Is it important to show the last value, or you need the latest date value?
If so use the max function.
LOAD CDHDR_KEY,
Max(PO_Appr.Date_TMP) as Last_PO_Apprv_Date,
LastValue(USERNAME) as Last_PO_Approver
Resident CDHDR_FINAL
Group By CDHDR_KEY;
G.
Thans a lot Gabor,
"Max" is working perfectly for Date,
But the last value is necessary for the Last_PO_Approver, which is name of the person, and the "LastValue" command doesn`t work correct as well:(
maybe this:
tab1:
LOAD
CDHDR_KEY,
Max(PO_Appr.Date_TMP) as Last_PO_Apprv_Date
Resident CDHDR_FINAL
Group By CDHDR_KEY;
left join
load
CDHDR_KEY,
PO_Appr.Date_TMP as Last_PO_Apprv_Date,
USERNAME as Last_PO_Approver
resident CDHDR_FINAL;
I hope it helps.
Hi Ivan. Not sure, but maybe an ordering will help
LOAD CDHDR_KEY,
LastValue(PO_Appr.Date_TMP) as Last_PO_Apprv_Date,
LastValue(USERNAME) as Last_PO_Approver
Resident CDHDR_FINAL
Group By CDHDR_KEY
Order by USERNAME, PO_Appr.Date_TMP;
Thanks a lot Andrey,
It`s working,
have a nice day:)