i have the following script which load data from excel i want to load only particular employee id as mention in script i used WHERE clause but it was not working...
For each ExcelFile in filelist ('*.xls')
EOM_HISTORY:
Load
EMP.CODE,
NAME as EmployeeName,
DESIGNATION ,
[D A T E] as Date,
//Last//Timestamp([T ME IN],'hh:mm:ss[.fff] TT') as Checkinn,
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 EMP.CODE in ('969','3436','2058','5009','3523','3638','4099');
Next ExcelFile;
STORE EOM_HISTORY into D:/attendance/att1.qvd(QVD);
