Help in Comparing data

[pratap19]

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!

[FilipR]

Please see attached.

[pratap19]

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.

[FilipR]

@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.

[FilipR]

Please check another variant.

[pratap19]

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!

[FilipR]

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).