3 Replies Latest reply: Jul 18, 2014 5:26 AM by Armand Ngaleu RSS

    List of sales Product

    Armand Ngaleu

      Hey evrybody, I have a 'small' problem, so I have the follow script

       

      Sales:
      LOAD * INLINE [
          code, OrderDate,total
          1, 16.07.2014,10
          2, 16.07.2014,52
          3, 16.07.2014,588
          1, 17.07.2014,855
           3, 17.07.2014,452
           4, 17.07.2014,542       
      ];
      
      code:
      NoConcatenate LOAD
      Distinct 
      code  
      Resident Sales;
      
      Left Join(code)
      
      LOAD
      code,
      OrderDate,
      total
      Resident Sales;
      
      DROP Table Sales;
      EXIT Script;
      

       

       

      I would like to get 2 lists:

       

      list of items that were sold the 16.07.2014  and were not sold the 17.07.2014
      code
      2

       

       

      list of items that were sold the 17.07.2014  and were not sold the 16.07.2014
      Code
      4

       

      Please could sombody helps me ? :-(

       

      thanks

      Best

      Army