Hello Guys,
I have two fields (Date_of_Approval) and CHANGENR.
I want to load CHANGENR asc then everyday of first record in my application please check the below example and required output.
Data:
| Date_of_Approval | [PR No] | CHANGENR |
| 4/30/2019 | 1101040481 | 0043087912 |
| 5/9/2019 | 1101040502 | 0043088215 |
| 5/29/2019 | 1101040514 | 0043097780 |
| 5/29/2019 | 1101040514 | 0043097789 |
| 6/12/2019 | 1101040521 | 0043101344 |
| 6/20/2019 | 1101040530 | 0043101731 |
| 6/20/2019 | 1101040530 | 0043101740 |
| 7/17/2019 | 1101040511 | 0043104002 |
| 7/17/2019 | 1101040516 | 0043104004 |
| 7/17/2019 | 1104003905 | 0043104005 |
| 7/18/2019 | 1101040541 | 0043104403 |
Required Output:
| Date_of_Approval | [PR No] | CHANGENR |
| 4/30/2019 | 1101040481 | 0043087912 |
| 5/9/2019 | 1101040502 | 0043088215 |
| 5/29/2019 | 1101040514 | 0043097780 |
| 6/12/2019 | 1101040521 | 0043101344 |
| 6/20/2019 | 1101040530 | 0043101731 |
| 7/17/2019 | 1101040511 | 0043104002 |
| 7/18/2019 | 1101040541 | 0043104403 |
Please help me the above issue.
Thank you
