Hi,
I am having issues while generating dates and flags. I am using generate rows but it's not working.
Appreciate if you could upload workflow.
Input
ID | Med | Date | Flag |
1 | A | 1-Jan | T |
1 | B | 22-Jan | M |
1 | C | 22-Jan | T |
1 | B | 22-Jan | T |
1 | D | 23-Jan | M |
1 | A | 10-Jun | I |
Output
ID | Med | Date | Min_Date | Max_Date | Current Flag | Next Flag |
1 | A | 1-Jan | 1-Jan | 22-Jan | T | M |
1 | A | 2-Jan | 1-Jan | 22-Jan | T | M |
1 | A | 3-Jan | 1-Jan | 22-Jan | T | M |
1 | A | 4-Jan | 1-Jan | 22-Jan | T | M |
1 | A | 5-Jan | 1-Jan | 22-Jan | T | M |
1 | A | 6-Jan | 1-Jan | 22-Jan | T | M |
1 | A | 7-Jan | 1-Jan | 22-Jan | T | M |
1 | A | 8-Jan | 1-Jan | 22-Jan | T | M |
1 | A | 9-Jan | 1-Jan | 22-Jan | T | M |
1 | A | 10-Jan | 1-Jan | 22-Jan | T | M |
1 | A | 11-Jan | 1-Jan | 22-Jan | T | M |
1 | A | 12-Jan | 1-Jan | 22-Jan | T | M |
1 | A | 13-Jan | 1-Jan | 22-Jan | T | M |
1 | A | 14-Jan | 1-Jan | 22-Jan | T | M |
1 | A | 15-Jan | 1-Jan | 22-Jan | T | M |
1 | A | 16-Jan | 1-Jan | 22-Jan | T | M |
1 | A | 17-Jan | 1-Jan | 22-Jan | T | M |
1 | A | 18-Jan | 1-Jan | 22-Jan | T | M |
1 | A | 19-Jan | 1-Jan | 22-Jan | T | M |
1 | A | 20-Jan | 1-Jan | 22-Jan | T | M |
1 | A | 21-Jan | 1-Jan | 22-Jan | T | M |
1 | B | 22-Jan | 22-Jan | 22-Jan | M | T |
1 | C | 22-Jan | 22-Jan | 22-Jan | T | T |
1 | B | 22-Jan | 22-Jan | 23-Jan | T | M |
1 | D | 23-Jan | 23-Jan | 10-Jun | M | I |
1 | D | 24-Jan | 23-Jan | 10-Jun | M | I |
1 | D | till 9-June | 23-Jan | 10-Jun | M | I |
1 | A | 10-Jun | 10-Jun | I |
Solved! Go to Solution.