help in script

Anonymous — Thu, 12 Oct 2017 13:26:23 GMT

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

Re: help in script

vkish16161 — Thu, 12 Oct 2017 20:12:39 GMT

No file attached

Anonymous — Thu, 12 Oct 2017 22:51:46 GMT

sorry missed the attachment before. PFA thnx