How to remove duplicates

0 votes
I have duplicate ticket fields in my database & I want to remove the duplicates that have older dates. E.g:

CustID | Date

AM10000 | 1/1/2017

AM10000 | 1/1/2018

GK17010 | 1/1/2018

so I want the answer to be

AM10000 | 1/1/2018

GK17010 | 1/1/2018
Apr 14, 2018 in Tableau by GandalfDwhite
• 1,320 points
409 views

1 answer to this question.

0 votes

Create a calculated field [Rank - Date] with below code:

RANK_UNIQUE((MAX(SPLIT([database field],'|',2))))
//This will create a values for every ticket

Now do this, to filter only date with max value and drag to filter and select True

[Rank - Date]=1

I guess this should work

answered Apr 14, 2018 by QueenBee
• 1,820 points

Related Questions In Tableau

0 votes
0 answers

How to remove horizontal lines on a text table in Tableau online?

In Tableau online, I built a text ...READ MORE

Mar 2, 2022 in Tableau by Vaani
• 7,070 points
434 views
0 votes
0 answers

How to export the IdP (Identity provider) XML Metadata from Keycloak which is imported to Tableau?

Keycloak version 1.6.1, Goal: Keycloak should act ...READ MORE

Mar 29, 2018 in Tableau by ffdfd
• 5,550 points
2,278 views
0 votes
1 answer

How can I use Tableau to create a heatmap?

Step 1: Create an Excel Spreadsheet with ...READ MORE

answered Apr 2, 2018 in Tableau by ffdfd
• 5,550 points
2,812 views
0 votes
1 answer

How to group bins in a tableau histogram?

One of the simple way is by ...READ MORE

answered Apr 3, 2018 in Tableau by xyz
• 1,560 points
6,755 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
9,767 views
+2 votes
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
1,537 views
+2 votes
1 answer
0 votes
1 answer

How to use a IFF statement in Tableau

Use this syntax -  IIF(([Avg_sale] > [Today]),STR([Avg_sal ...READ MORE

answered Apr 5, 2018 in Tableau by QueenBee
• 1,820 points
1,825 views
0 votes
1 answer

How to create a global filter

Assuming you have created a dashboard already, ...READ MORE

answered Apr 13, 2018 in Tableau by QueenBee
• 1,820 points
1,427 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP