I have a dataset that contains duplicate rows based on the “Event ID” primary key. I would like to keep only one row for each unique Event ID, and discard any additional rows that have a duplicate Event ID. The dataset has several other columns beyond just the Event ID, but I want to focus the dedu…

Hi This might be helpful. [image] Remove duplicate rows from dataset Question & Answer Thanks for the reply, but I have already tried your idea without luck. I don’t need a filter on the dashboard, I need less data in the dataset. Let me be more detailed. I create a c…

Hi @Joao_Nascimento , It’s been awhile since we last heard from you; did you have any additional questions regarding your initial topic? If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic. Thank you!

Hi @Joao_Nascimento , Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for any relevant information that may be needed. Thank you!

How to Remove Duplicate Rows by Event ID in a Dataset

Q&A

Shahid_Muhammad August 30, 2024, 7:38am 2

This might be helpful.

Topic		Replies	Views
How do I remove duplicates from the dataset when uploaded to quicksight? Q&A quick-sight , Business-Intelligence-Engineer	4	603	March 15, 2024
Remove duplicate rows from dataset Q&A direct-query , quick-sight	11	8871	October 15, 2024
Delete duplicate with Incrementally refreshing a dataset Q&A data-source , analysis , parameters , formatting , error , quick-sight , calculations	13	1770	March 2, 2023
Remove duplicates on quicksight Q&A developer , quick-sight , dashboard-embed	1	109	October 11, 2024
How can we use the primary key feature to avoid duplication during incremental refresh? Q&A quick-sight , dataset , Business-Intelligence-Engineer	3	135	July 28, 2025

How to Remove Duplicate Rows by Event ID in a Dataset

Related topics