topic Re: 5.6 INSERT AFTER LEFT OUTER JOIN in Talend Studio

5.6 INSERT AFTER LEFT OUTER JOIN

Anonymous — Tue, 05 Nov 2019 14:55:30 GMT

Hi everyone.

I'm still using talend 5.6.

I have a fact Table with somes Code And labels and a repository table with codes and labels too

And i want to insert the DISTINCT newlines from my table fact into my table repository

In my job, I have my first Entry with:

SELECT distinct Code, Labels From MY_TABLE_FACT

i have an other entry with

SELECT IDTECH, Code, Labels From MY_TABLE_REPOSITORY

And My tmap :

I have Lines in my input, a delta between Table_Fact > Table_repository

But no lines in the output.

Thank you for your help.

Re: 5.6 INSERT AFTER LEFT OUTER JOIN

TRF — Tue, 05 Nov 2019 17:03:11 GMT

Change "Join model" to "Inner Join" then for the output flow, set "Catch lookup inner join reject" to true.
This way you will have one record in the output flow for each fact table not existing into the repository.

Re: 5.6 INSERT AFTER LEFT OUTER JOIN

Anonymous — Wed, 06 Nov 2019 09:17:54 GMT

Hello and thank you very much for your answer

Unfortunatly, i have the same issue, No line in output

Re: 5.6 INSERT AFTER LEFT OUTER JOIN

Anonymous — Wed, 06 Nov 2019 09:20:35 GMT

Re: 5.6 INSERT AFTER LEFT OUTER JOIN

cterenzi — Wed, 06 Nov 2019 14:40:39 GMT

You need to confirm that the values that are joined match each other. If there's something slightly different about them (trimmed vs untrimmed, upper case vs lower case, etc.) you'll need to resolve that before joining the flows.