9 Replies Latest reply on Aug 14, 2019 2:41 PM by Chris McClellan

    DROP DUCPLICATES IN SEVERAL COLUMNS

    Marina Talyanskaya

      Dear users, I hope you can help me with the following:

       

      I have the table like this:

      usernamewebsitepagedatedate-timeactionother info
      anna.montbigdata.comnews22-07-201922-07-2019 22:11:37view5346hfjtm
      anna.montbigdata.comnews22-07-201922-07-2019 22:11:37openhe56i
      liza.arentpsabout-us22-07-201922-07-2019 23:16:14copy3464jlll

       

      I want to get something like with:

      usernamewebsitepagedatedate-timeactionother info
      anna.montbigdata.comnews22-07-201922-07-2019 22:11:37view5346hfjtm
      liza.arentpsabout-us22-07-201922-07-2019 23:16:14copy3464jlll

       

      Thus, I want to drop those raws that have the same date-time, website and username info, but are different in other columns (e.g. action or other info), so, how can I do that with Tableu Prep?