Hi all,
Solution statements:
Only for those records with topmost condition 08.* and the second condition counting from the top is 07.*,we need to identify the following 2 dates of change of condition: -corresponding date of topmost condition if 08.*, and; -corresponding date of condition 07.1
Record with ID A does not qualify as even thou its topmost condition is 08.2 (08.*), its second condition from the top is 08.1 (not 07.*)
Record with ID B does qualify as its topmost condition is 08.1 (08.*) and its second condition from the top is 07.2 (07.*); for this record we need to find the dates that correspond to condition 08.1 and 07.1 specifically (not 07.2)
Record with ID C does not qualify as, even thou its topmost condition is 08.2 (08.*), its second condition from the top is 08.1 (not 07.*)
Record with ID D does not qualify because its topmost condition is not 08.*
Record with ID E does qualify as its topmost condition is 08.1 (08.*) and its second condition from the top is 07.1 (07.*); for this record we need to find the dates that correspond to condition 08.1 and 07.1
| ID | Condition | Date of condition change |
| A | 08.2 | F1 |
| A | 08.1 | F2 |
| A | 07.3 | F3 |
| A | 07.2 | F4 |
| A | 07.1 | F5 |
| A | 06.1 | F6 |
| A | 05.1 | F7 |
| B | 08.1 | F8 |
| B | 07.2 | F9 |
| B | 07.1 | F10 |
| B | 06.1 | F11 |
| B | 05.1 | F12 |
| C | 08.2 | F13 |
| C | 08.1 | F14 |
| C | 07.1 | F15 |
| C | 06.1 | F16 |
| C | 05.1 | F17 |
| D | 07.3 | F18 |
| D | 07.2 | F19 |
| D | 07.1 | F20 |
| D | 06.1 | F21 |
| E | 08.1 | F22 |
| E | 07.1 | F23 |
Expected Selections
| ID | Date 1 | Date 2 | Result (substraction) |
| B | F8 | F10 | F8-F10 |
| E | F22 | F23 | F22-F23 |
Thanks,
Fernando Obando
