Akhter HUssain

Akhter HUssain

  • 712
  • 1.3k
  • 103.3k

Separat data in column SttusINOUT wise into two columns

Dec 17 2018 3:44 AM
I have data in column now i want to  separat it status wise one col Status(1)IN and Col(2)Out
 
EmpID
DateTime StatusINOUT
1 2018-05-26 08:44 1
1 2018-05-26 08:44 2
2 2018-05-28 08:44 1
2          2018-05-28 12:44 2                   
1 2018-05-21 08:44 1
1 2018-05-21 10:44 2
2 2018-05-23 08:44 1
2          2018-05-23 08:44 2                  

Now i want to display Status wise INTIME(1) and OUTTIME(2) it as below

Empid INTIME(1) OUTIME(2)
1 2018-05-26 08:44 2018-05-26 08:44
2 2018-05-28 08:44 2018-05-28 12:44
1 2018-05-21 08:44 2018-05-21 10:44
2 2018-05-23 08:44 2018-05-23 08:44

Answers (14)