how to use where function for excel data source

[#1]

Hi ,

Till now i am using oledb data source as

LOAD Name,Empid,date,transid;

SQL SELECT *

FROM ebc.dbo."AggregateTable"

where

EmpID in (3,28,55) and transid in (1,2,3);

Now i am getting data in excel source with same columns how to use where and in condition for excel source?

Could you please help me ASAP

Thanks

Rahul

[alexandros17]

place where exactly as in sql sysntax, sunstitute in with wildmatch(myField, 'TestVal1', Testval2 ...)

Hope it helps

[#3]

LOAD

*

FROM

  [*****.xls]

  (biff, embedded labels, table is [Sheet1$])

WHERE Match(Name,'a','b','c')>0

[bumin]

you can use where also for  excel data

but you have to input

where (EmpID = 3 or EmpID = 28  or EmpID =55) and (transid = 1 or Transid=2 or transid=3)

instead of using IN.

regards

Bumin

[arsal_90]

Load * From

ABC.xlsx

(biff, embedded labels, table is [Sheet1$])

where EmpID in (3,28,55) and transid in (1,2,3);

Or 

Load * From

ABC.xlsx

(biff, embedded labels, table is [Sheet1$])

where match(EmpID,'3','28','55') and match(transid,'1','2','3');

[bumin]

you have to enter

where match(EmpID,'3','28','55')>0 and match(transid,'1','2','3')>0;

[CELAMBARASAN · Accepted solution]

For excel you have to use QlikView syntax/functions

LOAD

     Name,

     Empid,

     date,

     transid

FROM

[Source]

WHERE Match(Empid, 3, 28, 55) AND Match(transid,1, 2, 3);

Hope it helps

[bumin]

where match(EmpID,'3','28','55') and match(transid,'1','2','3');

is the right syntax