Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
First one is actual data, the second is the required result.
Code:
let Start = floor(makedate(1971,01,01));
let End = floor(today())+1;
let NoOfDays = End - Start;
Cal1:
Load
$(Start)+recno()-1 as Date
autogenerate
$(NoOfDays);
Cal2:
Load
Year(Date) as Year
resident Cal1;
DROP Table Cal1;
A:
LOAD
Year,
Sales
FROM
SNO.xls
(biff, embedded labels, table is Sheet1$);
Final:
Left Join(Cal2)
Load
Year,
Sales,
Year as Year1
resident A;
Drop Table A;
All kind of suggestions/solutions are most welcome.
Thanks
Gangadharan
hei
attach is an example
Hi
Thanks a lot... It's working fine.