Load Particular ID from Excel

noman212 — Mon, 23 Jun 2014 10:34:53 GMT

Hi All,

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);

topic Load Particular ID from Excel in QlikView

Load Particular ID from Excel