Comparison in Tmap

Six Stars

Comparison in Tmap


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".

I coded as follows.

Var1: (row2.ESTAB_ID==((Var.Prev==0)?null:Var.Prev))?"YES":"NO" 

Var2: (row2.ESTAB_ID==0)?null:row2.ESTAB_ID 

Tmap is throwing an error stating null point exception. Experts please help me here...


Thanks in advance


Six Stars

Re: Comparison in Tmap


You can tUniqueRow component instead of tmap to filter the Duplicate records



Jilani syed