Filter Duplicate Values

Hi,

I would like to check if its possible to filter all duplicate with SAP ID.
image

so I can have a result thats similar to this.
image

I tried the Row Duplicate Filter but I cant achieve the result.
Thanks.

Hi @mjbasa ,

I gather that you are wanting to collect only the values that are duplicates.

This can be achieved using the options in the advanced tab on the Duplicate Row Filter. Please take a look at this post for assistance…

After the Duplicate Row Filter, attach a Row Filter or Row Splitter, and have that then filter out the items that have been marked by the Duplicate Row Filter as “unique” as you will want those that are marked as either “chosen” or “duplicate” which should be the list you are looking for

4 Likes