21 Replies Latest reply: Mar 14, 2017 5:48 AM by souad ouertani RSS

    Number of rows in a table

    souad ouertani

      I want to display the row number of the array, the column "nb" is the primary key,

      So I did a COUNT (nb), in the case I add the nb column to the array, the result is correct if I delete the column the tablau is incorrect

       

      first with nb column :

      cas1.PNG

       

       

      second without

      cas2.PNG

      the script :

      LOAD

           RowNo() as nb,

           MOIS,

           ANNEE,

           STAUT_CLIENT,

           MARCHE,

           DESCRIPTION_MARCHE_CLIENT,

           AGE_RELATION,

           DESCRIPTION_CATEGORIE_CLIENT,

           %ID_CATEGORIE_CLIENT,

           SEGMENT,

           CONQUETE,

           ANCIENNETE_RELATION,

           STATUT_AVA,

           PROD_AVA,

           %ID_AGENCE_CTOS_CLIENT,

           SOUS_MARCHE,

           SEGMENT_2015,

           TYPE_SOUS_MARCHE,

           NOMBRE_AVA

      FROM

      C:\pfe\DONNEES_RECAP\AVA.qvd

      (qvd);