Help in Comparing data

Question

Hi,

Can some one please help me with below case?

Date set 1: Employee current progression steps

EmployeeGradeStep1Step2Step3Step4A1StartLevel 10Level 15Level 17B1Level 10Level 15Level 17 C1Level 15StartLevel 17

Date set 2: Progression steps by grade should be as below

GradeStep1Step2Step3Step41StartLevel 10Level 15Level 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:

EmployeeGradeStep1Step2Step3Step4A1okokokokB1 okokokC1  okNot ok

Please some one help me with the flow for this challenged task.

Thanks in advance!

FilipR · Answer

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

Compare Steps with Matrix.yxmd

pratap19 · Answer

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

EmployeeGradeStep1Step2Step3Step4A1StartLevel 10Level 15Level 17B2Level 10Level 15Level 17 C3Level 15StartLevel 17

Date set 2: Progression steps by grade should be as below

GradeStep1Step2Step3Step41StartLevel 10Level 15Level 172StartLevel 10Level 19 3Level 10Level 15StartLevel 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:

EmployeeGradeStep1Step2Step3Step4A1okokokokB2 okNot okNot okC3 okokNot ok

Please help me with the flow for this challenged task.

Thanks in advance!

FilipR · Answer

Please check another variant.

New Workflow22.yxmd