topic Why Tmap comparison not working? in Talend Studio

Why Tmap comparison not working?

rp2018 — Tue, 19 Jun 2018 14:53:50 GMT

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 — Wed, 20 Jun 2018 07:56:47 GMT

try row2!=null

manodwhb — Wed, 20 Jun 2018 07:57:06 GMT

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

row1.ServiceTypeID ==null

manodwhb — Wed, 20 Jun 2018 07:59:33 GMT

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

row1.IndoorServiceTypeID <> row2.ServiceTypeID

fdenis — Wed, 20 Jun 2018 08:00:21 GMT

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 — Wed, 20 Jun 2018 08:08:47 GMT

@rp2018,check the below screenshoot.

manodwhb — Tue, 26 Jun 2018 11:34:01 GMT

@rp2018,still do you have this issue?