Filter Duplicate Values

[mjbasa]

Hi,

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

so I can have a result thats similar to this.

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

[takbb]

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…

Get all the rows that match for a given number of columns.

Hi @RoyBatty296 , so are you saying that you have a single table and you wish to find rows that are duplicated on those seven columns? If so, use the duplicate row filter. Specify the seven columns of interest, and on the advanced tab, choose the following options: [image] Follow this with either a row filter or row splitter, and for the filter criteria specify the following, to exclude those rows that are unique (i.e. don’t share the selected columns with at least one other row): [image] …

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