8 Replies Latest reply: Jun 5, 2014 7:57 AM by Srikanth P RSS

    Where clause

      Hi Everyone

       

      I would like to exlude values from a table that I load from an sql database with a "Where" clause. I just do not seem to get the syntax right...

       

      This is what I tried:

       

      LOAD [Invoice Number]  Where ([Invoice Number] <> 0)

       

      SQL SELECT..

       

      Thank you very much for your help!