Display duplicates rows

[MSportback1640560610]

I want to display all duplicates rows.

I have used tUniqRow but it return only the rows secondary duplicates.

My aim is to display rows first duplicates and all its duplicates together.

I found tMatchGroup, I think it what I need and it is not avaible for Open Studio.

There is alternative approch with Open Studio ?

Thanks

[Anonymous · Accepted solution]

Hi

Store these secondary duplicates into memory using tHashOutput.

In next subjob, read these duplicates rows from memory using tHashInput, and do an inner join with source data on tMap, select Match model as 'All matches'.

​

Hope it helps!

Regards

Shong

[MSportback1640560610]

Great thanks @Shicong Hong​