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!