Home › Forums › KX Academy › Fundamentals Capstone 4.3 › Re: Fundamentals Capstone 4.3
-
Hi !
Have you had a look at the template for returnN ?
I think a key feature that you could use is sublist – Sublist of a list | Reference | kdb+ and q documentation – Kdb+ and q documentation (kx.com)
So simply order the table by the column provided in ascending order then subset the first/last N records from the newly ordered table.
If you are still unsure, please feel free to reach out.
Many thanks,
Megan