8 Replies Latest reply: Feb 10, 2017 6:11 AM by mayuresh dabhekar RSS

    Exclude value in loading script

    Mike Slottje

      Hi guys,

       

      I have a script where I load all of my credits.

      There is one specific credit note that has to be excluded.

       

      I tried to do this by using the following expression in my script:

       

      Credit:

      LOAD

           No_ as [Item],

          "Sell-to Customer No_" as [Sell-to-Customer],

          "Document No_" as [Invoice Number]

      FROM ["our database".qvd]

      (qvd)

      WHERE([Invoice Number] <> 'Credit-1234')

       

      That didn't work. Would be great if you guys could help me out:)

       

      Mike