I need new tenure days when title has changed to the employee

[hemachandran]

I have attached the sample data. In that data i have month wise data at the month end.I have tenure days based on the DOJ. When the employee changes from one position to another position the DoJ has to change when changed date of the title. And it has to be the DOJ.

From that date i need new tenure days for the current position. please help on this..

Thanks in Advance..

[sunny_talwar]

Is this something you need in the script or front end?

[Anonymous]

so when employee changes the position..CAL date should be DOJ ?

Am I right?

[vinieme12]

See attached

[Anonymous]

Check it out

[hemachandran]

I need in script sunny..Thanks for ur response..Thanks in advance..

[hemachandran]

yes..correct..Thanks for ur response..Thanks in Advance..

[hemachandran]

Thanks for ur response i did not get correct answer...from ur answer...Can u try by using flag..when title is changed..

[hemachandran]

Thanks for ur response..Still i didnt get correct answer. I need new tenure when title changed. Its wants to start from 0.

Thanks in Advance

[vinieme12]

try this

EMPDATA:

LOAD  Empcode,

Empcode&'-'&Title as KEY,

     CalDate,

     Month,

     Year,

     Title,

     DOJ,

    if(len(DOJ)<1,CalDate,DOJ) as TitleDate

FROM

(ooxml, embedded labels, table is Sheet1)

;

EMP_LIST:

LOAD

  DISTINCT KEY,

  if(MAX(TitleDate)-MIN(TitleDate)=0,min(CalDate)-min(TitleDate),MAX(TitleDate)-MIN(TitleDate)) as TenureDays

RESIDENT EMPDATA

  GROUP BY KEY

  ;