Find key word in text using tRecordMatching

[Anonymous]

Hello,
I have two spreadsheets where I which to find matching records in a column from each spreadsheet.
So in spreadsheet1, col 1, I have the following:

Paint
Electrical
Plumbing
paint
Lights
Light
In Spreadsheet 2, col 1, I have the following:

This is a job that requires point
New electrical is needed
Plumber to replace tap
No lights working

So my match would need to show
Plumber = Plumber to replace tap
Light = No lights working
Etc etc

I have been looking at the following with some success but not perfect.

[Anonymous]

Could you please show us the output , And settings of tjoin ?

[Anonymous]

use variable in tmap
and put the this syntax "row1.Col1.toLowerCase().contains(row2.Col2.toLowerCase()) "
Then you would be able to get the existence of input col string in lookup col string.
Best !! 

[Anonymous]

Thanks Roy,
I tried your suggestion (thanks) and this is how it looks.









[img=177x100]https://www.talendforge.org/forum/img/members/26681/mini_blob_20160128-1134.png[/img]