topic Re: Where clause on load QVD and table in QlikView

Where clause on load QVD and table

cbaqir — Tue, 15 Dec 2015 23:33:37 GMT

The following load works from a QVD:

FROM
[..\QVD\01_Extract_QVD\APP_ELD.QVD]
(qvd)
where EXP_TYPE_CODE <> ('Operating') and ALT_REQUEST_ID like 'FC*';

but the same type of syntax does not work for a table via odbc:

FROM "IT_DW".dbo."DM_STAT_REQ_ALL_V"

where REQ_STATUS not in ('Not Submitted') and REQ_ID like 'FC*' ;

nor does:

FROM "IT_DW".dbo."DM_STAT_REQ_ALL_V"

where REQ_STATUS not in ('Not Submitted') and REQ_ID in ('FC*') ;

Help?

Re: Where clause on load QVD and table

sunny_talwar — Tue, 15 Dec 2015 23:50:42 GMT

Either you need to restrict this using SQL syntax to restrict the data or use Where statement in the preceding load. I would suggest the 1st method, but cannot really tell because I don't have expertise in SQL.

For second option:

LOAD *

Where Match(EXP_TYPE_CODE, 'Operating') and WildMatch(ALT_REQUEST_ID, 'FC*');

SQL SELECT FieldNames

FROM "IT_DW".dbo."DM_STAT_REQ_ALL_V"

Re: Where clause on load QVD and table

cbaqir — Wed, 16 Dec 2015 00:53:53 GMT

I think the syntax is what is wrong or that line is in the wrong order. I'm confused because this works:

Load *

SQL SELECT *
FROM "IT_DW".dbo."DM_STAT_REQ_ALL_V"
where REQ_STATUS not in ('Not Submitted') ;

Re: Where clause on load QVD and table

sunny_talwar — Wed, 16 Dec 2015 01:04:00 GMT

Not really sure how to do this in SQL. I still need to learn that, but I hope someone will be able to help you here

Re: Where clause on load QVD and table

cbaqir — Wed, 16 Dec 2015 01:07:10 GMT

Hey I think I got it...

LOAD WildMatch("REQ_ID", 'FC*') as REQ_ID,

SQL SELECT *
FROM "IT_DW".dbo."DM_STAT_REQ_ALL_V"
where REQ_STATUS not in ('Not Submitted')