5 Replies Latest reply: Jun 21, 2018 5:50 AM by Raman Singh RSS

    Group by date

    Raman Singh

      Hi,

       

      I am having some trouble trying to group fields by month/year. My end result is still bringing in day DDMMMYYYY but I only want the data grouped by MMMYYYY.

       

      Data Load Editor:

      Concatenate

      LOAD Only(DATE([Created],'MMMYYY')) as StockDate2,

      CustID,

      Location,

          sum(TotalQty) as Receipted2,

          sum([Length])/2.54 as Length,

          sum([Width])/2.54 as Width,

          sum([Height])/2.54 as Height

      Resident [L2-LocationInventory] group by CustID, Location, (DATE([Created],'MMMYYY'));


      For this data I am using a table to display my results:

       

      StockDate2CustIDLocationReceipted2LengthWidthHeight
      Jan2018AUK20101520
      Feb2018BUK50101015

       

      Would be grateful for any assistance.