Why Tmap comparison not working?

Four Stars

Why Tmap comparison not working?

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.

 

Capture3.PNG


Accepted Solutions
Thirteen Stars

Re: Why Tmap comparison not working?

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

 

row1.ServiceTypeID ==null

Manohar B
Thirteen Stars

Re: Why Tmap comparison not working?

@rp2018,still do you have this issue?

Manohar B

All Replies
Eleven Stars

Re: Why Tmap comparison not working?

try row2!=null

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Thirteen Stars

Re: Why Tmap comparison not working?

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

 

row1.ServiceTypeID ==null

Manohar B
Thirteen Stars

Re: Why Tmap comparison not working?

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

 

row1.IndoorServiceTypeID <> row2.ServiceTypeID

Manohar B
Eleven Stars

Re: Why Tmap comparison not working?

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

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Thirteen Stars

Re: Why Tmap comparison not working?

@rp2018,check the below screenshoot.

Untitled.png

Manohar B
Thirteen Stars

Re: Why Tmap comparison not working?

@rp2018,still do you have this issue?

Manohar B