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.
