topic Re: tMap adding Java method to the tMap join in Talend Studio

tMap adding Java method to the tMap join

Anonymous — Sat, 16 Nov 2024 01:58:03 GMT

Join Design

File A -----> tMap -----> Output
(row1)     ^
               |
               |
               |

File B
(row2)

I would like to join file A and file B using a tMap. I want to be able to make use of the tMap rejection logic.

I was trying to use something like row1.name_id.contains(row2.name_id) within the tMap for the join but cannot make it compile.

Any ideas?

Thank you
Peter

Re: tMap adding Java method to the tMap join

manodwhb — Tue, 07 Jul 2020 04:59:22 GMT

@pd_ , can you provide screenshot of tmap settings?

Re: tMap adding Java method to the tMap join

manodwhb — Tue, 07 Jul 2020 04:59:22 GMT

@pd_ , can you provide screenshot of tmap settings?

Re: tMap adding Java method to the tMap join

David_Beaty — Thu, 09 Jul 2020 17:14:25 GMT

Hi,

In the tMap for row2, click on the button "Enable/disable expression filter" (white arrow with a green plus), in there you can put the expression you're after. Though from the way you described it, it should probably be:

row2.name_id.contains(row1.name_id)

Re: tMap adding Java method to the tMap join

David_Beaty — Thu, 09 Jul 2020 17:14:25 GMT

Hi,

row2.name_id.contains(row1.name_id)