Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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