Rank but restarting after breaks
Hello Knime users i come with a bit of a specific problem i have a giant document with multiple people in it, these people are not allowed to work more than 7 consecutive Sundays SO i need some way to count how many consecutive cells have the same word in it here is an example
and here how i would like to be
Ofcorce it does not need to be EXACTLY like this but i do need some help in any way i would be able to at least know a person has 7 consecutive work days
thank you for your help