Why Tmap comparison not working?

[rp2018]

My lookup table is blank and have records in my source table and it is not inserting record 

to the lookup table.

Trying to do row1.IndoorServiceTypeID <> row2.ServiceTypeID comparision.

Here is a snapshot of my tmap.

[fdenis]

try row2!=null

[manodwhb · Accepted solution]

@rp2018,ServiceTypeID is integer data type so ,please use the below one.

row1.ServiceTypeID ==null

[manodwhb]

@rp2018,try the below on in lookup section of Active/unactive expresion fileter.

row1.IndoorServiceTypeID <> row2.ServiceTypeID

[fdenis]

sorry you are lookng for an exclusion join.
link the input on a comon id id1=1 id2=1
add filter on output table.
be careful to select all match

[manodwhb]

@rp2018,check the below screenshoot.

[manodwhb]

@rp2018,still do you have this issue?