I have a table with historic data where I need to set flags in load script if certain conditions are fulfilled.
Date | Action | |
03/01-2011 | REJUR | |
06/01-2011 | AS | |
09/01-2011 | COME | |
15/01-2011 | READV | I need to set flag here because REJUR is above and REJUR date >01/01-2011 |
16/01-2011 | REFGD | I need to set flag here because REJUR is above and REJUR date >01/01-2011 |
My problem is that there can be 0, 1, 2, 3, ….. 999 actions between REJUR and the other RE* and I need to flag the RE* if REJUR is above and REJUR date is greater than 01/01-2011.
Any ideas ?