I have a business requirement where i have to create a flag which iterates based on a specific task name and all the following tasks should have the same iterated value for the flag.
ID
Task Name
Flag
1
Creation
0
2
Check
0
3
Creation
0
4
Check
0
5
REVIEW
1
6
Creation
1
7
Check
1
8
Creation
1
9
Check
1
10
Creation
1
11
Check
1
12
REVIEW
2
13
Creation
2
14
Check
2
In the above example, i need the flag to iterate based on the field REVIEW and all other following tasks till the next REVIEW task should have the same Flag value.
