flag

[satishqlik]

Hi Viewers,

how to create flage for

same employees(emp id) which having different doj

Any help will be appreciated!

[tresB · Accepted solution]

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;

[satishqlik]

Thank you!!

This is what am exactly looking for............!!!