Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey all, I am stuck in converting this data in one line -
I want to get the field values only associated with the Max Date of [FileNameDate], Group by [PKey]
PKey | WEIGHT | Service Level | UPG_CODE | FileNameDate |
50242355891OLN0001 | 0.5 | GROUND | MI/with ATP disabled | 09/08/2019 |
50242355891OLN0001 | 1.4 | GROUND | - | 07/08/2019 |
50242355891OLN0001 | 0.5 | GROUND | MI/with ATP disabled | 08/08/2019 |
Result Should Look Like This: -
50242355891OLN0001 | 0.5 | GROUND | MI/with ATP disabled | 09/08/2019 |
Will really appreciate all help and opinions. Thanks a ton!
Hi
I hope you find this useful