6 Replies Latest reply: Jun 9, 2014 4:57 PM by Gonçalo Bernardino RSS

    Loading from a excel / txt file a value that I don't want to display on dashboard/query results

    Gonçalo Bernardino




      I am loading some data from another source (or maybe from excel/txt file) (the data are incident reference numbers), but I need to create an exception, that will ignore a specific reference number that I do not want to be included and displayed on my dashboard.



      How can I do that while loading the script?










        Date(Addmonths([Start Date], $(numMonth))) as [Start Date],

        Date(Addmonths([End Date], $(numMonth))) as [End Date],

        [Number of Transaction Days]

      FROM C:\excel.xls,

        except REF123456;



      Many thanks!