Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
You cannot select NULL-values.
You may
LOAD IF(LEN(TRIM(ProductName)) = 0, '#N/A', ProductName) AS ProductName_corr FROM ...
LET OTHERSYMBOL = +';
....
Products: LEFT KEEP YourTable LOAD Product_ID, ProductName FROM ...;
MissingProductName: LOAD * INLINE [Product_ID, ProductName
+, #N/A];
IF(LEN(TRIM(ProductName)) = 0, Product_ID)
HTH
Peter
Thanks both of these options work a treat
Dave