Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I'm sharing my dummy data and it contains
Emp,Date,Logintime,Gender,Route,Logintype
This scenario is actually
To allocate the cab for group of employees(1 cab for 4 employees) which is based on the
route and date and logintype and logtime and gender.
How do we achieve this(frontend/backend)???
Any suggestions will be appreciated.
PFB for your reference!!!
I have tried with creating flags using If condition
Load *
If(count(Emp)/4=mod(count(Emp),4),'Flag1') as MyFlag
Resident maindata
Groupby
Logintype,Date,Logintime,Gender,Route;
But it is not working .....
Any suggestions will be appreciated.