Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to determine the max date for my incremental load. But when I am using Peek function the variable is showing wrong format.
in source date is in below format:
My Script is:
Last_Date:
LOAD
Date (max(action_date$)) as MaxActionDate
FROM
(qvd);
let vMaxDate = Date(peek('MaxActionDate',0,'Last_Date'));
MaxActionDate is showing in right format:
But Variable vMaxDate is showing in wrong format:
Could you please help to get this correct.
Thanks,
Sarif
okk
this is very tricky.. do u have any good doc on the variable. Like when we will use Set and when Let. When we will use $ and when not.
Thanks a lot Sunny... you are always very helpful.