2 Replies Latest reply: Sep 11, 2016 10:05 AM by Oran Cohen RSS

    Peek orders from the last Year

    Oran Cohen

      Hi,

       

      I'm trying to peek orders from the last year but it doesn't work.

       

      LOAD

           [Order ID],

        Max(Year([Order Date])) As MaxOrderYearByOrder

      FROM [..\Qvd\FactOrders_6_Import.Qvd] (qvd)

      Group By [Order ID];

       

      Someone can explain me why ?

       

      *It must be in the ETL process

       

      Thank.