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

      Hi,

       

       

      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?

       

       

      Example:

       

       

       

       

      LOAD

        CycleTimeKey,

        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!