Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Could you post a sample data set and expected output against that?
This table is exactly what i need. the first value for the calculated field.
attachment is the sample data
PFA