9 Replies Latest reply: Sep 13, 2016 9:09 AM by Андрей Шепель RSS

    Load sales by max priority

    Андрей Шепель

      Hi everyone!

      I have some simple load from xls.

      Second operation - saving rows with max Priority field by group by function.

       

      My script:

      Main:

      LOAD DeliveryPoint,

           [Product type],

           Agent,

           Priority,

           Sales

      FROM

      [Max priority sales.xlsx]

      (ooxml, embedded labels, table is Лист1);

       

       

      right Join(Main)

      load

      DeliveryPoint,

      [Product type],

      max(Priority) as Priority

      Resident Main

      Group by DeliveryPoint,

      [Product type];

       

       

      It works fine, but in large volume data group by function take too much time (more one hour).

      Colleagues, is in QV some others ways to keep sales by following logic?

       

      Source file and model is attached.

      Thanks.