4 Replies Latest reply: Sep 16, 2016 4:37 AM by Mohammad Sarif RSS

    Using Not Exist

    Mohammad Sarif

      Hi All,

       

      I want to delete from qvd for few Units. I have created Inline load and used that in Not Exists function. Below is my code:

       

      UnitDelete:

      Load * Inline

      [DelUnit,

      10,

      100

      ];

       

       

      Transaction:

      LOAD

          CUSTOMER,

          "ABC #",

          "Invoice #",

          "Invoice Qty",

          "Invoice Type",

          "Total Extended Cost",

          Units,

         "Customer Group"

      FROM [lib://QVDs/Transactions_01_09132016.qvd](qvd)

       

      where Units not Exists (DelUnit,Units) ;

       

      But I am getting error. Could you please help me on this.

       

      Thanks in advance for your help.

       

      Regards,

      Sarif