Delete Succession value

chadliagabsi — Wed, 07 Feb 2018 14:12:12 GMT

Morning,

how can i delete succession value of 0 1 and need to show just the red case (input, output of employee).

My script :

T1:

load

DIRECTION ,MATRICULE,

MOIS,ANNEE

Resident D_

;

T2 :

load

MATRICULE_AGENT, MOIS, ANNEE,DIRECTION,

if(MATRICULE=Previous(MATRICULE) and DIRECTION<>Previous(DIRECTION) ,1,0) as FLAG

Resident T1

order by MOIS;

drop table T1;

left join(T2)

load

MATRICULE, DIRECTION, MOIS,ANNEE,

if(FLAG=1,1,0) as ENTREE,

if(FLAG=0,1,0) as SORTIE

Resident T2

order by MOIS;

TF:

load MATRICULE, DIRECTION, MOIS, ANNEE,

ENTREE, SORTIE

resident T2

order by MOIS;

drop Table T2 ;

Re: Delete Succession value

Anil_Babu_Samineni — Wed, 07 Feb 2018 14:16:42 GMT

Will you able to provide sample application to investigate? Perhaps provide few Inline rows to reload() ??

chadliagabsi — Wed, 07 Feb 2018 14:28:16 GMT

Hello ,