3 Replies Latest reply: Feb 21, 2011 6:38 AM by haycockd RSS

    Selecting blank records from a list

      Hi,

      I am trying to select blank records from a list or from my pivot table but there appears to be no "null" selection criteria. Am i miaaing something really obvious or do I need to edit my script

      I want Product_ Name to show blank records as well as populated fields.

       

       

       

       



       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

      LOAD

       

       

       

      'PROODUCT_NAME`'

       

       

       

       

       

       

       

       



       

       

      SQL

       

       

      SELECT

      *

      FROM

       

       

      TimeAnalysisOutputtbl;





      Thanks

      Dave

        • Selecting blank records from a list

           

          please try

           

          LOAD

          If(IsNull(PROODUCT_NAME),'Missing Names',PROODUCT_NAME) as PROODUCT_NAME;

          SQL

          SELECT

          *

          FROM

          TimeAnalysisOutputtbl;

          Now all product with Null value will be populated to "Missing Names" & also you are free to make selection to this irrespective to object type(either a list box or pivot table)



          • Selecting blank records from a list
            Peter Rieper

            You cannot select NULL-values.
            You may

            • rerun your table and identify them with a logical check:
              LOAD IF(LEN(TRIM(ProductName)) = 0, '#N/A', ProductName) AS ProductName_corr FROM ...
            • if Product-Name is derived from an outside table, linked via KEEP:
              LET OTHERSYMBOL = +';
              ....
              Products: LEFT KEEP YourTable LOAD Product_ID, ProductName FROM ...;
              MissingProductName: LOAD * INLINE [Product_ID, ProductName
              +, #N/A];
            • Use a calculated Expression in a Multibox:
              IF(LEN(TRIM(ProductName)) = 0, Product_ID)

              This should list you all the ID's, which then you may select to see further details
            • Similar can be done as calculated dimension in a report

            HTH
            Peter