Hi All,

I'm new to talend.Here,I have two tables.Table1 consists of

Id           Name
1            Jones
2             Ronaldo

table 2 consists of

Id            City

1              Newyork
2              Losangels
3              Washington

My final table output must be

Id      name             city
1      Jones              Newyork
2       Ronaldo          Losangles
3                            Washington


How can I configure in tMap component to get this final table output..I'm getting inconsistent result when I'm automapping these values in tMap..Can anyone suggest me please

Thanks
Krrish

Online