Hi All,
I think I may have found something that can not be done!
Basically, I have the below (this spans circa 6k rows but this is just a snippet)
I am trying to trim this data to nly keep the two most recent records based on reference number. So, the above would then be
I hope that makes sense?
Thanks in advance for any advice
I think I may have found something that can not be done!
Basically, I have the below (this spans circa 6k rows but this is just a snippet)
kf_Client_Reference_Number | From_Date |
0011 | 10/11/2014 |
0011 | 28/02/2014 |
0014 | 22/08/2016 |
0014 | 07/12/2015 |
0014 | 14/08/2014 |
0014 | 06/09/2013 |
0016 | 19/09/2016 |
0016 | 02/09/2015 |
0016 | 02/09/2014 |
0016 | 17/09/2013 |
I am trying to trim this data to nly keep the two most recent records based on reference number. So, the above would then be
kf_Client_Reference_Number | From_Date |
0011 | 10/11/2014 |
0011 | 28/02/2014 |
0014 | 22/08/2016 |
0014 | 07/12/2015 |
0016 | 19/09/2016 |
0016 | 02/09/2015 |
I hope that makes sense?
Thanks in advance for any advice