[resolved] Issue with a tMap left outer join

[SHTalend]

Having problems with a tMap join. I need to identify if a value is a company, by checking if it contains a value in a list. I want the output to be the name and a true/false. On a true reading I get the results, but on the false reading I get nothing. I'm joining to the lookup table with a Left Outer join.

Join Model - The default Join Model is Left Outer Join, that is, if no matching row appears in the look-up input, rows from the primary will still be output.






                                                     

[Anonymous]

Are you sure your left outer join is working? In your third screenshot, 1 row is getting passed but it's not getting displayed in the output. Why can't you just drop the row1.Name column in front of row3? Is there a specific reason to include contains condition?