My thread's title's quite confusing so I'll try to elaborate. I have the following data set
<colgroup><col span="2"><col><col><col><col><col></colgroup><tbody>
</tbody>
and I want to create a flag that would indicate whether employee's business title has been amended over the years<body id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
<tbody>
</tbody></body>; that would suggest a promotion for example. So, in the sample pasted I'd like to create a new column where the red highlighted entries would have a flag i.e."Title Changed" or whatever.
The reason why there are multiple entries of the same employee is because there is a quarter effective date which takes a snapshot of the employees count, status etc.
Any thoughts?
| effective_date | UNIQUE_ID | emp_id | full_name | length_of_service | Status | emp_business_title |
| 30-04-16 | 704287Sina Mirzad | 704287 | Sina Mirzad | 5.13 | Senior Account Executive (SMB) | |
| 31-07-16 | 704287Sina Mirzad | 704287 | Sina Mirzad | 5.38 | Senior Account Executive (SMB) | |
| 31-10-16 | 704287Sina Mirzad | 704287 | Sina Mirzad | 5.63 | Senior Account Executive (SMB) | |
| 30-04-16 | 705704Lauryn Coit | 705704 | Lauryn Coit | 4.82 | Account Executive (SMB) | |
| 31-07-16 | 705704Lauryn Coit | 705704 | Lauryn Coit | 5.07 | Account Executive (SMB) | |
| 31-10-16 | 705704Lauryn Coit | 705704 | Lauryn Coit | 5.32 | Senior Account Executive (SMB) | |
| 30-04-16 | 706291Baldev Singh | 706291 | Baldev Singh | 4.65 | Account Executive (SMB) | |
| 31-07-16 | 706291Baldev Singh | 706291 | Baldev Singh | 4.9 | Account Executive (SMB) | |
| 31-10-16 | 706291Baldev Singh | 706291 | Baldev Singh | 5.15 | Account Executive (SMB) | |
| 30-04-16 | 706560Giselle Peck | 706560 | Giselle Peck | 2.14 | Account Executive (SMB) | |
| 30-04-16 | 707098Jayann Raguini | 707098 | Jayann Raguini | 4.4 | Senior Account Executive (SMB) | |
| 31-07-16 | 707098Jayann Raguini | 707098 | Jayann Raguini | 4.65 | Senior Account Executive (SMB) | |
| 31-10-16 | 707098Jayann Raguini | 707098 | Jayann Raguini | 4.9 | SMB Strategic Account Executive |
<colgroup><col span="2"><col><col><col><col><col></colgroup><tbody>
</tbody>
and I want to create a flag that would indicate whether employee's business title has been amended over the years<body id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
| emp_business_title |
<tbody>
</tbody>
The reason why there are multiple entries of the same employee is because there is a quarter effective date which takes a snapshot of the employees count, status etc.
Any thoughts?
