additional modification

ryanzhang487

For this part, is there a way to optimize it?

1, for example, in real situation the step names are not simply going in sequence like C1, C2, C3, it will be like CL1/1(step 1), CTSD12(step 2), CDD (step 3), so taking the last number and add 1 does not work, it will have to link to the standard table to find out what next step is before joining

2, if start step = finish step =  last step, then the start step will auto adjust one step back, (in the workflow you created if "W3" then "W2" because we know W3 is the last step), but in real situation we don't know if start step is the last step, the way to know this is to link to the standard table when the below row's accumulative time = 0

I hope that make sense and thank you again

Final with date and Manual error accomodation (4).yxmd

worker actual input (1).xlsx

fixed standard.xlsx

ShankerV

Hi @ryanzhang487 

I have few questions while tweaking the workflow.

1. How to handle Step Start = Step finish

i.e which one needs to be handled

For example, do I need to modify in such a way that, Step start is moved back to previous step

or

Step finish needs to be moved to 1 step ahead

I have a problem if I need to move one step ahead of Step finish, where it might move more than the last step.

2. Also do you want to handle the situation of C4 comes into picture.

Or can we delete those steps?

If it needs too be handled, please give more overview on which step needs to be rolled back.

Thanks in advance.

I see you have added a lookup table, that looks very good, 

I have converted the steps to standard format which will always help in translation.

Many thanks

Shanker V

09022023 Can you help to achieve this logic in alteryx details please see the excel.yxmd