Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Viewers,
how to create flage for
same employees(emp id) which having different doj
Any help will be appreciated!
Ohh, got it. Use Floor() like:
t1:
LOAD id,
Date(floor(doj),'DD-MMM-YY') as doj,
type
FROM
[modify.xlsx]
(ooxml, embedded labels, table is May);
LOAD id,
Date(floor(doj),'DD-MMM-YY') as doj,
type
FROM
[modify.xlsx]
(ooxml, embedded labels, table is Jun);
join
LOAD
id,
Count(DISTINCT doj) as count
Resident t1
Group By id;
final:
LOAD*,
If(count>1,1,0) as flag1
Resident t1;
DROP Table t1;
Thank you!!
This is what am exactly looking for............!!!