topic Re: Left outer join of two tables in Talend Studio

Left outer join of two tables

_AnonymousUser — Sat, 16 Nov 2024 14:30:51 GMT

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.

Re: Left outer join of two tables

Anonymous — Fri, 16 Nov 2007 08:16:59 GMT

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

Re: Left outer join of two tables

_AnonymousUser — Thu, 20 May 2010 09:15:51 GMT

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

Re: Left outer join of two tables

Anonymous — Thu, 20 May 2010 10:05:55 GMT

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|
'--+-----+---'

Re: Left outer join of two tables

_AnonymousUser — Fri, 30 Jan 2015 09:53:48 GMT

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 !

Re: Left outer join of two tables

Anonymous — Wed, 20 Jul 2016 21:50:19 GMT

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