Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Jan 24, 2018, 3:14 PM

Removing duplicates in Custom SQL query

Hi,

 

I have created a query to pull information from SQL database.   There are a lot of joins and as a result  duplicates.  I want to filter out the duplicates based on ticket number.  The below works in the SQL database but somehow not for tableau.  Any suggestions?

 

SELECT

  count(distinct(a_change.NUMBER)),

8 answers
  1. Deepak Rai
    Jan 25, 2018, 6:06 AM

    Hi Tamisha,

    Pl check screenshots and attached. You need to use Last Function  and Compute using Ticket ID and Drag it to Filter and Set Filter True.

     

    Duplicated Tickets Data

     

    Hi Tamisha,Pl check screenshots and attached. You need to use Last Function and Compute using Ticket ID and Drag it to Filter and Set Filter True.

     

    Filter :

    LAST ()=0 , Drag it to FILTER and Select TRUE, Right Click Compute on Ticket ID and again Select TRUE to get only 1 Value for TICKET ID.

     

    Only One Row per Ticket ID

    pastedImage_3.png

     

    Thanks

    Deepak

Write an answer...
0/9000