topic Using the WHERE Clause in an ODBC connection string in QlikView

Using the WHERE Clause in an ODBC connection string

Thu, 04 Apr 2013 16:34:20 GMT

Hello,

Can anybody confirm whether or not I can use a WHERE clause in an ODBC connection?

For example:

I am able to connect to a MS Access Database and return all values as per below:

Script:

ODBC CONNECT32 TO [MS Access Database;DBQ=C:\Users\hayetom\Qlikview\Examples\Product.accdb];

LOAD `Product_ID`,

`Product_Line`;

SQL SELECT *

FROM `DIM_Prod`;

Which returns:

Product_ID	Product_Line
1	VL
2	VL
3	AB
4	AB
5	AB
6	CD
7	CD
8	EF

However, I only want to return rows Where the Product_Line is either 'VL' or 'AB'. I have tried

ODBC CONNECT32 TO [MS Access Database;DBQ=C:\Users\hayetom\Qlikview\Examples\Product.accdb];

LOAD `Product_ID`,

`Product_Line`;

SQL SELECT *

FROM `DIM_Prod` WHERE (Product_ID = 'VL' or Product_ID = 'AB');

NOTE: I appreciate that I can bring all the rows in and then limit my selection on the resident Load BUT I want to limit the data that is brought in the qvw to begin with.

Any ideas?

Re: Using the WHERE Clause in an ODBC connection string

Larry_Aaron — Thu, 04 Apr 2013 17:11:23 GMT

Try this for your where clause.

where Product_ID in('VL','AB')

Re: Using the WHERE Clause in an ODBC connection string

danielrozental — Thu, 04 Apr 2013 18:05:21 GMT

Try referring to the field as it appears in the SELECT.

where `Product_ID` in('VL','AB')

Re: Using the WHERE Clause in an ODBC connection string

Thu, 04 Apr 2013 22:10:36 GMT

Try using Product_Line in your Where clause, rather than Product_ID