How to do a join in tMap with value containing the other

kakooo16 — Fri, 02 Jul 2021 21:22:51 GMT

Hello

Supposed that i have a table A (columnA , columnB)

And tableB (columnC,columnD)

----'------------------'-------

ColumnA | column B

----'--------------------------

123456Ab | ok

------------------------------'

-------------------------------

ColumnC | ColumnD

--------------------------------

1234 | jack

---------------------------------

how To do my join if columnC contains ColumnA

I tried to do the match with contains but i didn t get a rzsult .

Any suggestion .

Thanks

Re: How to do a join in tMap with value containing the other

wcfsmart — Sun, 04 Jul 2021 16:56:25 GMT

Hi,

On talend, there is no join option call "contains"

My suggestion:

1) you do a cross join (add the two tables and that's all)

2) filter the output using contains

Here is the result: