1 Reply Latest reply: Nov 7, 2011 1:25 PM by Kiran Rokkam RSS

    Removing duplicate entries

      Hi All,

       

      I have a multiple file data feed that I am trying to combine whilst removing duplicates, but am having trouble selecting only the latest entries.

       

      To make this simple, I have create two data files (1.xls and 2.xls) and want to combine these to one table using the sequence and maximum date to show what the description is - why does this create multiple lines in the qvw attached?

       

      Any help will be very gratefully received.

       

      Kind Regards

       

      Becky