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 13, 2018 in Tableau by GandalfDwhite
• 1,320 points
19 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 13, 2018 by QueenBee
• 1,810 points

Related Questions In Tableau

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 28, 2018 in Tableau by Atul
• 5,530 points
506 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 Atul
• 5,530 points
720 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,550 points
1,264 views
0 votes
1 answer

How to use tableau to searh for text within entire data

You can use a pivot table in ...READ MORE

answered Apr 4, 2018 in Tableau by xyz
• 1,550 points
65 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
2,221 views
+1 vote
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
99 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_sale ...READ MORE

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

How to create a global filter

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

answered Apr 12, 2018 in Tableau by QueenBee
• 1,810 points
63 views