Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
in this document i loaded Sales table data from excel.
after that using resident load for OrderDate Ascending
but its not worked. AND Also declared a variable for its not worked .
Kindly find attached file
Regards,
k
Hi,
Use single quotes for the varaible like
Let varMinDate =Num(Peek( 'OrderDate',-1,'t1' ));
Regards
Anand
Sample... Work Accordingly
t1:
Load * Inline
[
OrderDate
10-10-2014
15-01-2014
05-04-2014
];
Temp:
Load Date(Max(OrderDate)) as MaxDate Resident t1;
Let vMaxDate = NUM(PEEK('MaxDate',0,'Temp'));