Number of rows in a table

[souadouert]

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 :

second without

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);

[souadouert]

thank i tried and it worked correctly thank y

[souadouert]

yes thank you