5.6 INSERT AFTER LEFT OUTER JOIN

[Anonymous]

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.

[TRF]

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.

[Anonymous]

Hello and thank you very much for your answer

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

[Anonymous]

[cterenzi]

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.