Selecting blank records from a list

[#1]

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

[#2]

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)

[prieper]

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

[#4]

Thanks both of these options work a treat

Dave