4 Replies Latest reply on Jun 19, 2018 11:46 PM by Shinichiro Murakami

Removing duplicates conditionally

Joyanne Lizotte Jun 19, 2018 9:47 PM

Hello,

Does anyone know how to remove duplicates conditionally? I have a large dataset where I'm trying to count items only once per site. For example my dataset looks like this:

Site 1	Item A
Site 1	Item A
Site 1	Item B
Site 2	Item A
Site 2	Item B
Site 2	Item B
Site 2	Item C

And I'd like to remove the duplicate items for each site, so it looks like this:

Site 1	Item A
Site 1	Item B
Site 2	Item A
Site 2	Item B
Site 2	Item C

There are other columns as well so the rows are not true duplicates, but I'm happy to ignore the rest of the data for now.

Help please!

1. Re: Removing duplicates conditionally

Shinichiro Murakami Jun 19, 2018 9:39 PM (in response to Joyanne Lizotte)

HI Joyanne,

It depends I believe.
When you bring Site and Item as dimensions, duplication does not matter.

I think you have measure value as well and tried to pick up one , but without full scope of your task, it's quite difficult to suggest.
Please attach your set of data as twbx format.

Thanks,
Shin
Like Show 0 Likes(0)

Actions
2. Re: Removing duplicates conditionally

Sohan Jawar Jun 19, 2018 10:22 PM (in response to Joyanne Lizotte)

I you just drag only the 2 columns in the rows shelf in tableau it will automatically show the grouped data. i.e removing the duplicates showing the values only once.

Incase if you use any other dimension along with this it may just expand as per the different values the dimension has in sites and Item.

Regards
Sohan.
Like Show 0 Likes(0)

Actions
3. Re: Removing duplicates conditionally

Joyanne Lizotte Jun 19, 2018 11:20 PM (in response to Sohan Jawar)

Hi Sohan,

What I'd like to do is count the total number of time each item is selected, but only count it once for each site. Any ideas on how to do it?

Thanks,

Joyanne
Like Show 0 Likes(0)

Actions
4. Re: Removing duplicates conditionally

Shinichiro Murakami Jun 19, 2018 11:46 PM (in response to Joyanne Lizotte)

We still need to see your data.
Please Please Please attach twbx and clarify your expectation.

Shin
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Removing duplicates conditionally

1. Re: Removing duplicates conditionally

2. Re: Removing duplicates conditionally

3. Re: Removing duplicates conditionally

4. Re: Removing duplicates conditionally

Actions

More Like This