We have a system which generates a csv output each day.
We need to remove any duplicates in the file, leaving the one with the lowest price (separate field). e.g:
So we need to remove Item 5 £6.99, and leave Item 5 £2.99.
We would like this to be tagged onto the completion of the previous script running if possible, if this is not possible we will need to set it up as a cron job estimating when we expect the other script to complete.
If you are able to do this please let us know