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:

       

      X

      Y

      Frequency_field

       

      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!

       

      GPC