2 Replies Latest reply: Jun 21, 2016 11:31 AM by Marcus Malinow RSS

    Do not load when empty

    Isabelle Timmermans

      Hi,

       

      I have a dataset which has a total at the end.

      I don't want to load it into my dataset.

      How can I do that?

       

      DateValueRemark
      21/6/20165This is the data i want to load
      20/6/20164This is the data i want to load
      19/6/20163This is the data i want to load
      This is an empty row which i want to delete
      12This is the total row, which i don't want to load

       

      I tried:

      LOAD

           'Source1' As Source,

           [date],

           Value

       

      FROM [lib://location.xlsx]

      (ooxml, embedded labels)

      Where [date] <> '';

       

      Please help!

       

      Thanks in advance,

      Isabelle