topic Re: Display duplicates rows in Talend Studio

Display duplicates rows

MSportback1640560610 — Fri, 15 Nov 2024 23:22:23 GMT

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

Re: Display duplicates rows

Anonymous — Mon, 27 Dec 2021 02:30:45 GMT

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

Re: Display duplicates rows

MSportback1640560610 — Tue, 28 Dec 2021 01:04:43 GMT

Great thanks @Shicong Hong