6 Replies Latest reply: Jun 21, 2016 6:21 PM by Sunny Talwar RSS

    filtering out NULL

    Robert Winkel

      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';