How to differentiate duplicate entries in tmap

[snirwane1606714631]

Hi my Input is

PRODUCT

AAAA

BBBB

CCCC

DDDD

DDDD

EEEE

Output1

AAAA

BBBB

CCCC

EEEE

Output2

DDDD

What expression shall I use in tmap

[Anonymous]

Hi

First, use tUniqueRow to get the duplicated entries, in next subjob, read the source data again and do an inner join with the duplicated entries, get the unmatched rows, please see the screenshots.

 

Hope it helps you!

Regards

Shong