Left outer join of two tables

Not applicable

Left outer join of two tables

I am new to talend
Now i am using Talend2.2
with the help of tmap transformation whether we can do left outer join of the two tables.
when you generarte a surrogate key which transformation can i use to generate surrogate key.
Community Manager

Re: Left outer join of two tables

Hi
yes, you can do left outer join in tMap component. I have created a job like this:
tFileInputCSV_1:
1,Alise,39
2,Bluce,49
3,Zlan,39
4,Yan,59

tFileInputCSV_2:
Alise,39
Bluce,49
Eliy,54
Ally,32

Please see the screenshot
Best regards
shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Left outer join of two tables

Hi Shong,
What about Left Join these 2 input files having data like these:
tFileInputCSV_1:
ID,Name
1,Alise
2,Bluce
3,Zlan
4,Yan
tFileInputCSV_2:
ID,Age
1,18
3,25
One Star

Re: Left outer join of two tables

LNuqui: I think you can do this like that (see screenshots).
Results :
.--+-----+---.
| tLogRow_1 |
|=-+-----+--=|
|ID|Name |Age|
|=-+-----+--=|
|1 |Alise|18 |
|2 |Bluce|null|
|3 |Zlan |25 |
|4 |Yan |null|
'--+-----+---'
One Star

Re: Left outer join of two tables

Hi
yes, you can do left outer join in tMap component. I have created a job like this:
tFileInputCSV_1:
1,Alise,39
2,Bluce,49
3,Zlan,39
4,Yan,59

tFileInputCSV_2:
Alise,39
Bluce,49
Eliy,54
Ally,32

Please see the screenshot
Best regards
        shong

Hello Shong !
Sorry to reply to this (very) old thread, but I'm facing a similar issue, and I can't see the screenshot you provided.
Could you please show it ?
Thanks !
One Star

Re: Left outer join of two tables

I cant see the screen shots either... Shong please advise