3 Replies Latest reply on May 29, 2013 8:59 AM by Robert Morton

    Remove duplicate rows based on Acct (Choose most recent date)

    Steve DeLillo

      Hi, I have a table that has around 11M records. Every time a change is made to an account a new record is created, the key fields being Account # and Modified Date. I am looking for a way to filter (and basically create a new table) that has only the most recent record (Modified Date) for each account. Is this something I need to do via SQL or can it be done in Tableau...If it is SQL can someone point me in the right direction.

       

      Thanks,
      Steve