Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Below given is the sample data in which for one Policy there are Two or Three Premium values. I want a maximum value for that policy only through script so that will become my base data for further calculation.
Please suggest how I can achieve this in script
Policy_no | Premium | Name |
12345678 | 5000 | Jon |
10002345 | 100000 | Joseph |
12345688 | 40000 | Kern |
12345278 | 60000 | Ritu |
12345678 | 3000 | Jon |
10002345 | 200000 | Joseph |
12345688 | 60000 | Kern |
12345278 | 40000 | Ritu |
12345688 | 100000 | Kern |
12345278 | 800000 | Ritu |
5678945 | 25000 | Jeevan |
369874 | 123980 | Kiran |
Final Out_put should be like this..
Policy_no | Premium | Name |
12345678 | 5000 | Jon |
10002345 | 200000 | Joseph |
12345688 | 100000 | Kern |
12345278 | 800000 | Ritu |
5678945 | 25000 | Jeevan |
369874 | 123980 | Kiran |
Thanks in advance..
Happy to help Please mark the question as answered so the thread can be closed.
Very good thread Petter - rescued me from a difficult situation
Thank you