Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to use where function for excel data source

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

1 Solution

Accepted Solutions
CELAMBARASAN
Partner - Champion
Partner - Champion

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

View solution in original post

7 Replies
alexandros17
Partner - Champion III
Partner - Champion III

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

Hope it helps

Not applicable
Author

LOAD

*

FROM

  [*****.xls]

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

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

bumin
Partner - Creator II
Partner - Creator II

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
Creator III
Creator III

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
Partner - Creator II
Partner - Creator II

you have to enter

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

CELAMBARASAN
Partner - Champion
Partner - Champion

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
Partner - Creator II
Partner - Creator II

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

is the right syntax