2 Replies Latest reply: Oct 18, 2011 9:45 AM by James Gilpin RSS

    find top sequence number per row in QVD

      My source qvds have a descending sequence that determines the latest version of the row, for example:

       

      5,a
      4,a
      3,a
      2,a
      1,a
      4,b
      3,b
      2,b
      1,b
      3,c
      2,c
      1,c
      1,d
      2,e
      1,e


      would result in

       

      5,a
      4,b
      3,c
      1,d

      2,e

       

      How would I limit the input data to show the current values from the qvd?

       

      James