Comparison in Tmap

[Anonymous]

Hi,

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

Crteja

[jilanisyed]

Hi 

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

Thanks

Jilani syed