6 Replies Latest reply: Jan 18, 2018 4:49 AM by An Pham RSS

    sorting in load

    souad ouertani

      Hello,

      I have a qvd file with a customer list with score and agencies,

      ID_CLIENT|agence|name|score


      I want to sort the customer by agency according to the score and only take the first 20 for each agency


      LOAD %ID_CLIENT,

          ID_Client

      agence

      score

      FROM

      [C:\Users\90160\Desktop\hautde gamme\HGFINAL.qvd]

      (qvd)

      group by agence

      order by score desc

       

       

      but i have error script