Comparison in Tmap

Six Stars

Comparison in Tmap

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

Six Stars

Re: Comparison in Tmap

Hi 

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

 

Thanks

Jilani syed