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.
Solved! Go to Solution.
@binsell I don't see file date in the file you have uploaded; can you provide an example with 2 different students?
@binsell
We need to use the "Group by Column" feature of the Sample tool as below.
Thank you so much @Qiu :)