Adding a flag to the earliest action for each case
Wondering if you can help, i have some data in the format of the table below. I need to add a flag (flag must be a 1 not a date) to the earliest closure record of each case
Can anyone think of the best approach? I am adding the flag through a resident load which is joined back to the original table. I'm not sure whether i need to write a loop to look at all records under each case id, if so i'd appreciate some guidence on that. Thank you in advance
Worked example should clarify / confirm - see attached data & QVW. Note that my data will also show that should there be multipe records for a single case with the same Close Date then both will be flagged.