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

2 ACCEPTED SOLUTIONS

Accepted Solutions
Twelve Stars

Re: Why Tmap comparison not working?

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

 

row1.ServiceTypeID ==null

Manohar B
Twelve Stars

Re: Why Tmap comparison not working?

@rp2018,still do you have this issue?

Manohar B
6 REPLIES
Ten Stars

Re: Why Tmap comparison not working?

try row2!=null

Francois Denis

Don't forget to tag when it's "solved"!

Twelve Stars

Re: Why Tmap comparison not working?

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

 

row1.ServiceTypeID ==null

Manohar B
Twelve 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
Ten 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

Don't forget to tag when it's "solved"!

Twelve Stars

Re: Why Tmap comparison not working?

@rp2018,check the below screenshoot.

Untitled.png

Manohar B
Twelve Stars

Re: Why Tmap comparison not working?

@rp2018,still do you have this issue?

Manohar B