Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Any Suggestion??
Src:
LOAD Required???,
WeekDay,
SampleDate,
WeekNumber,
Week(SampleDate) As WeekNo
FROM
[Sample File.xlsx]
(ooxml, embedded labels, table is Sheet1);
Join(Src)
Load WeekNo,'Week'&AutoNumber(RecNo(),Mth) As Weeks ;
Load WeekNo,Max(Month(SampleDate)) as Mth Resident Src Group by WeekNo Order by WeekNo asc;