How to merge records from two different fields from same table

[#1]

Flag:

LOAD EmpID,Date,

   if(frac(min(Time))<=$(vEarlyTime),'Early','Late') as FlagEarly,

   if(frac(max(Time))>=$(vOverTime),'Over','Within') as FlagOver

Resident EmployeeTimeData

Group By EmpID,Date;

by using this i am getting

FlagEarly/Late             FlagOver/Within

Early                          Over

Late                            Within

But i want to have

Flag

Early

Late

Over

Within

i am trying with nested if something like

Flag1:

LOAD EmpID,Date,

     if(Frac(Min(Time))<=$(vEarlyTime),'Early',if(Frac(Min(Time))>$(vEarlyTime),'Late',if(Frac(max(Time))>=$(vOverTime),'Over',if(Frac(max(Time))<$(vOverTime),'Within')))) as Flag

   Resident EmployeeTimeData

Group By EmpID,Date;

but it is giving

Flag

Early

Late

so please help me how to achieve this

[#2]

EmployeeTimeData:

LOAD id,

     EmpID,

     EventID,

     Date,

     Time

FROM

FlagData.xlsx

(ooxml, embedded labels, table is Sheet2);

ABC:

LOAD EmpID ,Date,

   if(time(frac(min(Time)))<='$(vEarlyTime)','Early','Late') as Flag

Resident EmployeeTimeData

Group By EmpID,Date;

Concatenate

load EmpID,Date,

if(time(frac(max(Time)))>='$(vOverTime)','Over','Within') as Flag

Resident EmployeeTimeData

Group By EmpID,Date;

drop table EmployeeTimeData;

inner join

LOAD id,

     EmpID,

     EventID,

     Date,

     Time

FROM

FlagData.xlsx

(ooxml, embedded labels, table is Sheet2);

[#3]

still in flag field only two records(Late,over) it is showing for this script