Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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 ;
;
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
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 ;
;
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.
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
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 ;
or
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 ;
My mistake avinash. The ID was being loaded from another table
you were right first time!