https://community.qlik.com/t5/Talend-Studio/Comparison-in-Tmap/m-p/2308470#M79795 <P>Hi,</P><P>I want to send duplicate records into one target and distinct records into another one. I was trying to create variable ports and try to compare both and generate a flag for duplicates "YES" for non duplicates "NO".</P><P>I coded as follows.</P><P>Var1: (row2.ESTAB_ID==((Var.Prev==0)?null:Var.Prev))?"YES":"NO"&nbsp;</P><P>Var2:&nbsp;(row2.ESTAB_ID==0)?null:row2.ESTAB_ID&nbsp;</P><P>Tmap is throwing an error stating null point exception. Experts please help me here...</P><P>&nbsp;</P><P>Thanks in advance</P><P>Crteja</P> Tue, 16 Jan 2018 21:54:38 GMT Anonymous 2018-01-16T21:54:38Z https://community.qlik.com/t5/Talend-Studio/Comparison-in-Tmap/m-p/2308470#M79795 <P>Hi,</P><P>I want to send duplicate records into one target and distinct records into another one. I was trying to create variable ports and try to compare both and generate a flag for duplicates "YES" for non duplicates "NO".</P><P>I coded as follows.</P><P>Var1: (row2.ESTAB_ID==((Var.Prev==0)?null:Var.Prev))?"YES":"NO"&nbsp;</P><P>Var2:&nbsp;(row2.ESTAB_ID==0)?null:row2.ESTAB_ID&nbsp;</P><P>Tmap is throwing an error stating null point exception. Experts please help me here...</P><P>&nbsp;</P><P>Thanks in advance</P><P>Crteja</P> Tue, 16 Jan 2018 21:54:38 GMT https://community.qlik.com/t5/Talend-Studio/Comparison-in-Tmap/m-p/2308470#M79795 Anonymous 2018-01-16T21:54:38Z https://community.qlik.com/t5/Talend-Studio/Comparison-in-Tmap/m-p/2308471#M79796 <P>Hi&nbsp;</P><P>You can tUniqueRow component instead of tmap to filter the Duplicate records</P><P>&nbsp;</P><P>Thanks</P><P>Jilani syed</P> Wed, 17 Jan 2018 07:37:23 GMT https://community.qlik.com/t5/Talend-Studio/Comparison-in-Tmap/m-p/2308471#M79796 jilanisyed 2018-01-17T07:37:23Z