"Retrieve the attendance code ‘M’ for a student over three or more consecutive days. For instance, if P or R line items in attendance code, Skip it and continue logic
For example,
Expected output
Hi @jose.ordonez1 ,Thanks for your swift response. I’m looking for a solution where consecutive attendance = M for 3 or more times and it should break the chain if it has attendance other than P,K.
Dear,
Please find the attached workflow. Before write line, you can print outputDt in excel using write range activity.
forum.zip (3.9 KB)
Input Data table I used:-
Output :-
