topic How to differentiate duplicate entries in tmap in Talend Studio https://community.qlik.com/t5/Talend-Studio/How-to-differentiate-duplicate-entries-in-tmap/m-p/2309751#M80936 <P>Hi my Input is </P><P>PRODUCT</P><P>AAAA</P><P>BBBB</P><P>CCCC</P><P>DDDD</P><P>DDDD</P><P>EEEE</P><P></P><P></P><P>Output1</P><P>AAAA</P><P>BBBB</P><P>CCCC</P><P>EEEE</P><P></P><P></P><P>Output2</P><P>DDDD</P><P></P><P></P><P>What expression shall I use in tmap</P><P></P><P></P> Sat, 16 Nov 2024 01:02:08 GMT snirwane1606714631 2024-11-16T01:02:08Z How to differentiate duplicate entries in tmap https://community.qlik.com/t5/Talend-Studio/How-to-differentiate-duplicate-entries-in-tmap/m-p/2309751#M80936 <P>Hi my Input is </P><P>PRODUCT</P><P>AAAA</P><P>BBBB</P><P>CCCC</P><P>DDDD</P><P>DDDD</P><P>EEEE</P><P></P><P></P><P>Output1</P><P>AAAA</P><P>BBBB</P><P>CCCC</P><P>EEEE</P><P></P><P></P><P>Output2</P><P>DDDD</P><P></P><P></P><P>What expression shall I use in tmap</P><P></P><P></P> Sat, 16 Nov 2024 01:02:08 GMT https://community.qlik.com/t5/Talend-Studio/How-to-differentiate-duplicate-entries-in-tmap/m-p/2309751#M80936 snirwane1606714631 2024-11-16T01:02:08Z Re: How to differentiate duplicate entries in tmap https://community.qlik.com/t5/Talend-Studio/How-to-differentiate-duplicate-entries-in-tmap/m-p/2309752#M80937 <P>Hi </P><P>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. </P><P><span class="lia-inline-image-display-wrapper" image-alt="0693p00000AZzf7AAD.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/137976iD6BD58BBC4CA7650/image-size/large?v=v2&amp;px=999" role="button" title="0693p00000AZzf7AAD.png" alt="0693p00000AZzf7AAD.png" /></span><span class="lia-inline-image-display-wrapper" image-alt="0693p00000AZzf2AAD.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/129637iE2A3261B62CF3264/image-size/large?v=v2&amp;px=999" role="button" title="0693p00000AZzf2AAD.png" alt="0693p00000AZzf2AAD.png" /></span>&nbsp;</P><P>Hope it helps you!</P><P>&nbsp;</P><P>Regards</P><P>Shong</P> Mon, 30 Nov 2020 06:51:24 GMT https://community.qlik.com/t5/Talend-Studio/How-to-differentiate-duplicate-entries-in-tmap/m-p/2309752#M80937 Anonymous 2020-11-30T06:51:24Z