Data loading

[potti222]

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

[Sue_Macaluso]

@potti222 Are you using QlikView or Sense? I would like to move this into the correct product forum. 

[Anil_Babu_Samineni]

PFA