Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)의 질문
Tableau Community Forums Member (Inactive) (Salesforce) 님이 #Tableau Desktop & Web Authoring에 질문했습니다
2018년 1월 24일 오후 3:14

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개
  1. Deepak Rai
    2018년 1월 25일 오전 6:06

    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

답변을 작성하세요...
0/9000