Missing values in the result of left outer join

[rolandnemeth]

Hello all,

I want to make a left outer join (as VLookup in Excel).
The joining column in the left table contains all values as the joining column of the right table.
Despite of this in the result table of the joiner (left outer join) I got missing values.

Could anyone help with this issue?

Best Regards,
Roland

[ipazin]

Hello @rolandnemeth,

this is probably some kind of misconfiguration or different data type issue. Can you share print screens of Joiner’s configuration? Or even better a workflow where this can be seen?

Br,
Ivan

[rolandnemeth]

I have found the solution, the Joiner Node makes difference between uppercase and lowercase string values.