hi all,
can anyone help to achieve the below result.
i have attached the sample data below. need to apply the below 3 cases.
1. if type='cancel' take the 'id' and find the same 'id' from the previous record and delete both the records.
2. if mid=id then update the old record amt & hd_amt from the new record (as per date).
3. if if id>1 the only keep the latest record (as per date) drop all other rows for the same which contains the same id.
can refer 'expected result' in the same excel file for the output which i require.
thanks in advance
