topic Re: QVD load and WHERE clause in QlikView

QVD load and WHERE clause

Mon, 05 Oct 2015 12:01:28 GMT

There's something wrong with my syntax here in the WHERE clause, but i can't work it out

Activities:

load * from [\\fsdata01\department\eCommerce\BIU\Dataloads\Salesforce\QVDs\Activities.qvd] (qvd)

WHERE Activities.Type NOT LIKE ('Email','Minor communication') AND Subject NOT NULL;

Peter_Cammaert — Mon, 05 Oct 2015 12:05:59 GMT

NOT keyword should negate a comparison.

Try your WHERE like this:

WHERE Not (Activities.Type LIKE '*Email*') AND Not (Activities.Type LIKE '*Minor communication*') AND Not IsNull(Subject);

Note that QlikView LOAD statements may look like SQL SELECT statements, but they are not identical.

Best,

Peter

avinashelite — Mon, 05 Oct 2015 12:06:51 GMT

try like this:

Activities:

load * from [\\fsdata01\department\eCommerce\BIU\Dataloads\Salesforce\QVDs\Activities.qvd] (qvd)

Where not WildMatch(Activities.Type,'Email','Minor communication') AND len(trim(Subject))>0 ;

;

Anonymous — Mon, 05 Oct 2015 12:08:37 GMT

Alex, You could also have a look at the Match() function. Will do the same as Peter's suggestion, but with a touch less typing to do.

Mon, 05 Oct 2015 13:03:32 GMT

Avinash, the rows I am wish to excluded are still being loaded for some reason, except that the Subject and Type are coming through as blank.

I need the rows totally excluded from the load

avinashelite — Mon, 05 Oct 2015 13:10:42 GMT

Try like this :

Activities:

load * from [\\fsdata01\department\eCommerce\BIU\Dataloads\Salesforce\QVDs\Activities.qvd] (qvd)

Where not WildMatch(Activities.Type,'*Email*','*Minor communication*') AND len(trim(Subject))>0 ;

Activities:

load * from [\\fsdata01\department\eCommerce\BIU\Dataloads\Salesforce\QVDs\Activities.qvd] (qvd)

Where not WildMatch(upper(Activities.Type),'*EMAIL*','*MINOR COMMUNICATION*') AND len(trim(Subject))>0 ;

avinashelite — Mon, 05 Oct 2015 13:11:30 GMT

Mon, 05 Oct 2015 13:16:03 GMT

My mistake avinash. The ID was being loaded from another table

you were right first time!