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

[kakooo16]

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

[wcfsmart]

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: