How to Remove Duplicate Rows by Event ID in a Dataset

[Joao_Nascimento]

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 deduplication process on just the Event ID column.

The challenge is that I am unable to perform any ETL work on the dataset. I need to find a way to remove the duplicate rows directly within the QuickSight platform, preferably at the dataset level, to make it easier for the business users to create their analyses.

What is the best approach to identify and remove these duplicate rows in QuickSight, keeping only a single row for each unique Event ID?

Thank you in advance for your help!

[Shahid_Muhammad]

Hi

This might be helpful.

Remove duplicate rows from dataset

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 calculate fields like this vibrationMaxValue = maxOver({l3dspmaxvalue},[{t042}],PRE_FILTER) In this way vibrationMaxValue will have a max value within t042 parition. This is right, but I need to exclude all duplicated values and I don’t know how to create. I tryied to change that field in vibrationMaxValue = ma…