topic how to use where function for excel data source in QlikView

how to use where function for excel data source

Tue, 15 Apr 2014 08:53:41 GMT

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

Re: how to use where function for excel data source

alexandros17 — Tue, 15 Apr 2014 08:56:05 GMT

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

Hope it helps

Re: how to use where function for excel data source

Tue, 15 Apr 2014 08:58:04 GMT

LOAD

FROM

[*****.xls]

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

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

Re: how to use where function for excel data source

bumin — Tue, 15 Apr 2014 08:58:37 GMT

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

Re: how to use where function for excel data source

arsal_90 — Tue, 15 Apr 2014 09:02:57 GMT

Load * From

ABC.xlsx

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

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

Load * From

ABC.xlsx

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

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

Re: how to use where function for excel data source

bumin — Tue, 15 Apr 2014 09:08:50 GMT

you have to enter

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

Re: how to use where function for excel data source

CELAMBARASAN — Tue, 15 Apr 2014 09:12:47 GMT

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

Re: how to use where function for excel data source

bumin — Tue, 15 Apr 2014 09:36:59 GMT

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

is the right syntax