filtering out NULL

[#1]

this is the out put

I need to not show the blanks  I am doing a direct connect so the filter is cluttered

example of other data

[Facilities]:
LIB CONNECT TO [pmd-sandbox (pharmore_rwinkel)];
LOAD [FacID],
[FacName];
SQL SELECT  "FacID",
  "FacName"
FROM "Fac"."dbo"."Facilities";

[FacilityCustomFields]:
LIB CONNECT TO [pmd-sandbox (pharmore_rwinkel)];
LOAD [FacID],
[CFID],
[CFValue];
SQL SELECT  "FacID",
  "CFID",
  "CFValue"
FROM "Fac"."dbo"."FacilityCustomFields";
THis is where I am trying to remove the blanks   WHERE CFValue IS NOT Null

[CustomFieldDefs]:
LIB CONNECT TO [pmd-sandbox (pharmore_rwinkel)];
LOAD [CFName],
[CFID];
SQL SELECT  "CFName",
  "CFID"
FROM "FwLTC"."dbo"."CustomFieldDefs"
I added this to filter down to just two descriptions in field heading  WHERE CFName = 'v2016 (MM-DD-YY)' or CFName = 'v2016 Clarification Needed';

[Anonymous]

I personally would use

Where  len(CFValue)>0

but there will be other ways to achieve it.

[#3]

Did I miss something?  see row 19

.

[Anonymous · Accepted solution]

Your semicolon is before the where statement it needs to be after it.

[#5]

[Anonymous]

FROM "Fac"."dbo"."FacilityCustomFields"
WHERE len(CFValue)>0;

Only one semicolon.

[sunny_talwar]

I think you are trying to put a QlikView syntax in SQL Statement, I would suggest using a SQL syntax to restrict, but in QlikView you can restrict in the preceding load....

LOAD *

Where Len(Trim(CFValue)) > 0;

SQL  SELECT

*

FROM ....