4 Replies Latest reply: Sep 27, 2013 5:23 AM by Gareth Campbell RSS

    Top 3 x for each y in load script

      Hi All,


      I have to pull out the top 3 x's for each y based on a frequency field during the load script.


      My data is in the following format:






      I have been playing around with recno() but can't get it to restart for each X... Does anyone have any elegant solutions to this problem?


      Thanks in advance!