in a tMap I have a lookup. I am expecting it to return all rows when "All matches" is selected. In my example it only returns one result (which is null, and there is no record with a null value in it.
Please help me figure this out.
Overview of the job part:
the tLogRow displayes the results, which should be passed on to the next component with tmap
this is how the tMap looks like
The Field formats all also soom correct.
without data hard to answer 100% correct
but Your configuration mean:
return ALL ROWS from row46 - this is 1 row only
and all rows from pruefe_leere which matched with row46
Your described result mean - no one matched rows, and it 100% correct return for You only 1 row with null result
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema