Hi,
Can some one please help me with below case?
Date set 1: Employee current progression steps
Employee | Grade | Step1 | Step2 | Step3 | Step4 |
A | 1 | Start | Level 10 | Level 15 | Level 17 |
B | 1 | Level 10 | Level 15 | Level 17 | |
C | 1 | Level 15 | Start | Level 17 |
Date set 2: Progression steps by grade should be as below
Grade | Step1 | Step2 | Step3 | Step4 |
1 | Start | Level 10 | Level 15 | Level 17 |
Desired output:
1) Compare Step 1 progression in Data set 1 with Data set 2 to find out at what step the employee started with!
2) Check whether the employee followed exactly same steps follows in Data set 2
Example: Employee B started at Level 10. That is Step2 in Dat set 2. Now the employee next levels in Data set1 should match with Step3 and Step4 in Data set 2.
Example output:
Employee | Grade | Step1 | Step2 | Step3 | Step4 |
A | 1 | ok | ok | ok | ok |
B | 1 | ok | ok | ok | |
C | 1 | ok | Not ok |
Please some one help me with the flow for this challenged task.
Thanks in advance!
Hi Filip,
Thank you for your reply. I didn't find any where you are comparing Data set1 with Data set2. The comparison should be between Planned progression(i.e. Data set2) with actual employee progression.
Can you please help me on this!
Thanks in advance.
@pratap19 Isn't the progression always the same for all users, though? I am checking if the level number is higher for the next step (I am assigning number 1 to Start beforehand, since it didn't have any).
I mean, you probably have more grades with different steps, but I assume Step2 is never of a lower level than Step3.
Hi Filip,
Thanks for the reply. That was close to what I need. But please go through the below updated criteria and help me please.
Date set 1: Employee current progression steps
Employee | Grade | Step1 | Step2 | Step3 | Step4 |
A | 1 | Start | Level 10 | Level 15 | Level 17 |
B | 2 | Level 10 | Level 15 | Level 17 | |
C | 3 | Level 15 | Start | Level 17 |
Date set 2: Progression steps by grade should be as below
Grade | Step1 | Step2 | Step3 | Step4 |
1 | Start | Level 10 | Level 15 | Level 17 |
2 | Start | Level 10 | Level 19 | |
3 | Level 10 | Level 15 | Start | Level 19 |
Desired output:
1) Compare Step 1 progression in Data set 1 with Data set 2 to find out at what step the employee started with!
2) Check whether the employee followed exactly same steps follows in Data set 2
Example: Employee B started at Level 10. That is Step2 in Dat set 2. Now the employee next levels in Data set1 should match with Step3 and Step4 in Data set 2.
Example output:
Employee | Grade | Step1 | Step2 | Step3 | Step4 |
A | 1 | ok | ok | ok | ok |
B | 2 | ok | Not ok | Not ok | |
C | 3 | ok | ok | Not ok |
Please help me with the flow for this challenged task.
Thanks in advance!
I don't quite understand your output example. Employee B should be OK / Not ok / Not ok / Null (or Not ok), while you start with a blank and say that Employee B's Step 2 (which is marked as "Level 15") was OK.
Please check the updated workflow. I'm marking if the step the Employee took was valid or not based on the matrix (and assuming an Employee could have skipped some steps, but couldn't go back to Step 2 after doing Step 3 already).