i have the following script
How can i pick file from sharing pc?
For each ExcelFile in filelist ('*.xls')
EOM_HISTORY:
Load
EMP.CODE ,
NAME as EmployeeName,
DESIGNATION ,
[D A T E] as Date,
//TO_DATE as CalendarDate,
Day([D A T E]) AS CalendarDayOfMonth,
WeekDay([D A T E]) AS CalendarDayName,
Week([D A T E]) AS CalendarWeekOfYear,
Month([D A T E]) AS CalendarMonthName,
'Q' & Ceil(Month([D A T E])/3) AS CalendarQuarter,
Year([D A T E]) AS CalendarYear,
// Calendar TO_DATE Names
WeekName([D A T E]) as CalendarWeekNumberAndYear,
MonthName([D A T E]) as CalendarMonthAndYear,
QuarterName([D A T E]) as CalendarQuarterMonthsAndYear,
// Start TO_DATEs
DayStart([D A T E]) as CalendarDayStart,
WeekStart([D A T E]) as CalendarWeekStart,
MonthStart([D A T E]) as CalendarMonthStart,
QuarterStart([D A T E]) as CalendarQuarterStart,
YearStart([D A T E]) as CalendarYearStart,
// End TO_DATEs
DayEnd([D A T E]) as CalendarDayEnd,
WeekEnd([D A T E]) as CalendarWeekEnd,
MonthEnd([D A T E]) as CalendarMonthEnd,
QuarterEnd([D A T E]) as CalendarQuarterEnd,
YearEnd([D A T E]) as CalendarYearEnd,
Time(Time#(Num(Hour([T ME IN]),'00')&Num(Minute([T ME IN]),'00')&Num(Second([T ME IN]),'00'), 'hhmmss')) as Time,
ENT.TYPE as status
From $(ExcelFile) (biff, embedded labels, table is [rptCUMTIMESHEETAll.rpt$], filters(Remove(Row, RowCnd(CellValue, 1, StrCnd(equal, 'Information Systems')))))
WHERE WildMatch(EMP.CODE,'1','2','3','4','5','67','7','8','9','10','11','12','13','14','15','16')and Time(Time#(Num(Hour([T ME IN]),'00')&Num(Minute([T ME IN]),'00')&Num(Second([T ME IN]),'00'), 'hhmmss')) <= '11:00:00';
Next ExcelFile;
