[resolved] Issue with a tMap left outer join

SHTalend — Sat, 16 Nov 2024 10:03:36 GMT

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.

Re: [resolved] Issue with a tMap left outer join

Anonymous — Tue, 21 Feb 2017 17:37:54 GMT

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?

topic Re: [resolved] Issue with a tMap left outer join in Talend Studio

[resolved] Issue with a tMap left outer join

Re: [resolved] Issue with a tMap left outer join