Why Tmap comparison not working?

Five 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
Forteen Stars

Re: Why Tmap comparison not working?

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

 

row1.ServiceTypeID ==null

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Forteen Stars

Re: Why Tmap comparison not working?

@rp2018,still do you have this issue?

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

All Replies
Eleven Stars

Re: Why Tmap comparison not working?

try row2!=null

Francois Denis

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

Forteen Stars

Re: Why Tmap comparison not working?

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

 

row1.ServiceTypeID ==null

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Forteen 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
Don't forget to give kudos/accept the solution when a replay is helpful.
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!

Forteen Stars

Re: Why Tmap comparison not working?

@rp2018,check the below screenshoot.

Untitled.png

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Forteen Stars

Re: Why Tmap comparison not working?

@rp2018,still do you have this issue?

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch