Drop duplicate / Get the unique value
Any idea how to drop duplicate values by 2 columns?
Here is the example. I want to get the first row if there's a duplicate value by 2 columns (customer_id , orderid)
I've done with making a count distinct by new variable (concat customer id and order id ), but the value isn't correct yet.
Topic tableau visualization
Category Data Science