tMap adding Java method to the tMap join

[Anonymous]

Join Design

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

             File B
             (row2)

File A
src_id | name_id
1 | SmithJohn
2 | DaykinTom
3 | LinnMalissa
3 | MassBarbara

File B
key_fob | name_id
A | SmithJohnA
B | DaykinTomT
C | LinnMalissaG
d | MassBarb

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

[manodwhb]

@pd_ , can you provide screenshot of tmap settings?

[manodwhb]

@pd_ , can you provide screenshot of tmap settings?

[David_Beaty]

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)

[David_Beaty]

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)