4 Replies Latest reply: Jul 10, 2017 8:25 AM by Carlos Pulgarin RSS

    Autonumber:

    Carlos Pulgarin

      HELP, I Have This script, but it doesn't count it, in the date order:

       

      Imposicion2:

       

       

      first 30000 LOAD

      date,

      ID,

      AutoNumber(Rowno(), ID) as Cuenta   

         

      FROM [lib://Compartidosecreto/PST\Imposicion.qvd]

      (qvd);


      The result is:


      cuenta            Date                  ID

      1               05/03/2013               1

      2               14/06/2013               1

      3               26/03/2013               1

      4               17/04/2013               1




      But i wolud like, the result like this:


      cuenta            Date                  ID

      1               05/03/2013               1

      4               14/06/2013               1

      2               26/03/2013               1

      3               17/04/2013               1