32 Replies Latest reply: May 25, 2015 12:22 PM by Jessica Lee RSS

    Using Where Len(Trim())>0 statement to eliminate null values

    Jessica Lee



      I'm pulling time series data where it's listing out all of the dates regardless of whether there's a corresponding value.   I tried using the Where statement, len(trim())>0 in the data editor, but nothing's changing.  





          Date#("date",'YYYY-MM-DD') AS DATE,

           value as AlabamaRGDP,

           value as [REAL GDP],

          'Alabama' as [STATE]

      FROM [lib://Real Total Gross Domestic Product by State for Alabama]

      (XmlSimple, table is [observations/observation])

      WHERE len(trim(value))>0  ;