Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
place where exactly as in sql sysntax, sunstitute in with wildmatch(myField, 'TestVal1', Testval2 ...)
Hope it helps
LOAD
*
FROM
[*****.xls]
(biff, embedded labels, table is [Sheet1$])
WHERE Match(Name,'a','b','c')>0
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
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');
you have to enter
where match(EmpID,'3','28','55')>0 and match(transid,'1','2','3')>0;
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
where match(EmpID,'3','28','55') and match(transid,'1','2','3');
is the right syntax