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
Jun 18, 2017, 11:59 AM

Filtering duplicate data in Excel connector

Hi!

 

I have connected to an Excel data source. The data source contains data items per row with a handful of columns.

I want to filter out some data items depending on the data in one special column (a "duplicate" is defined here as matching in this special column). I want the "first" data items to appear in the data. But further occurences filtered out. At best, I could define "first" depening on a timestamp value in another column.

 

Using a filter in the data source I only have been able to filter out _all_ items where duplicates occur. But I want to keep the first occurence.

How can this be done?

 

Thanks!

Chris

11 answers
  1. Tableau Community Forums Member (Inactive) (Salesforce)
    Jun 19, 2017, 6:48 AM

    Hello Christoph,

     

    The raw data i have refered:

     

    NameDateStatusA6/19/2017DuplicateB6/19/2017DuplicateC6/19/2017Non DuplicateD6/19/2017Non DuplicateA6/18/2017DuplicateB6/18/2017Duplicate

     

    Here is the output:

    Hello Christoph, The raw data i have refered: NameDateStatusA6/19/2017DuplicateB6/19/2017DuplicateC6/19/2017Non DuplicateD6/19/2017Non DuplicateA6/18/2017DuplicateB6/18/2017Duplicate Here is the outpu

     

    To achieve this, you just need to create a calculated field as below:

    IIF(([Status]='Duplicate' AND [Date]={FIXED [Name],[Status]:MIN([Date])})

    OR [Status]='Non Duplicate',

    TRUE,

    FALSE)

     

    Put this into filter shelf as true. I have attached the sample workbook also.

     

    AK

Write an answer...
0/9000