Record with the latest date to be returned

[binsell]

Hi all - I was hoping someone could kindly help me with my issues. I have a number of rows of data for all the same student (identified by ownstu + sessionid)  and will see I have a column called 'File date'. I want to return the latest file date for that student and will have 2 lines of data. 

I have attached a before and after so you can see what I'm trying to achieve. 

What I have done so far is sorted the data by the students ownstu+sessionid,then file date, then used the sample to return the first 2 rows of data. This worked when I tested one student but when I brought in the rest of my data, it just returned that one students data and lost all the rest. 

Thanks for your help in advance. 

[aatalai]

@binsell I don't see file date in the file you have uploaded; can you provide an example with 2 different students?

[Qiu · Accepted solution]

@binsell 
We need to use the "Group by Column" feature of the Sample tool as below.

[binsell]

Thank you so much @Qiu :)