First line Value

[chadliagabsi]

Morning ,

I need to show just the first line  for each MATRICULE_ID. i affect 1 in Entrees_AG for the first line and - for the rest.

my script :

LOAD

MATRICULE_AGENT,

MOTIF,

DATE_DEB_TEMP, MOIS, ANNEE

Resident D_VUE_DAA ;

Tab_intermediaire:

load RowNo() as ROWID,

MATRICULE_AGENT,VALEUR,DATE_DEB_TEMP,MOTIF,MOIS, ANNEE,

if(VALEUR=1,1) as Motif_A,

if(VALEUR=0,1) as Motif_B

Resident Tab_initiale

ORDER BY ROWID, MATRICULE_AGENT ;

drop Table Tab_initiale;

Thanks.

[tresesco]

Could you post a sample data set and expected output against that?

[chadliagabsi]

This table is exactly what i need. the first value for the calculated field.

attachment is the sample data

[tresesco · Accepted solution]

PFA