Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
chadliagabsi
Creator II
Creator II

Delete Succession value

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 ;

Sans titre.png

2 Replies
Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
chadliagabsi
Creator II
Creator II
Author

Hello ,