Remove duplicates on quicksight

Question & Answer
,
1

How to retain first occurrence of data in Merging column and remove all other duplicates?
I have marked unique/duplicate based on the merging column data

|Name| Merging |unique/duplicate|

|aaaaaaaaaaa|BWI110PDCM-48|Unique|
|aaaaaaaaaaa|BWI110PDCM-54|Unique|
|aaaaaaaaaaa|BWI110PDCM-22|Unique|
|aaaaaaaaaaa|BWI110PDCM-72|Unique|
|aaaaaaaaaaa|BWI110PDCM-14|Unique|
|aaaaaaaaaaa|BWI110PDCM-39|Unique|
|aaaaaaaaaaa|BWI110PDCM-20|Duplicate|
|aaaaaaaaaaa|BWI110PDCM-20|Duplicate|
|aaaaaaaaaaa|BWI110PDCM-34|Unique|
|aaaaaaaaaaa|BWI110PDCM-18|Duplicate|
|aaaaaaaaaaaBWI110PDCM-18|Duplicate|

2

Hello @mudunup , welcome to the QuickSight community!

There’s a few ways to achieve this. The simplest option is to apply a filter on all of your sheets for your unique/duplicate field to exclude all rows that say “duplicate”.

You could also apply the same filter on your dataset in the dataset layer.