topic Re: How to use tMap to combine two tables with different headers in Talend Studio

How to use tMap to combine two tables with different headers

Anonymous — Sat, 16 Nov 2024 08:16:35 GMT

Hello, I currently have 2 tables that I would like to combine. However, when I try combining them using tMap, the columns from one of the table is empty.

Here is the first table:

ID | Username | Age

1 | Adam | 19

2 | Sam | 21

3 | Alex | 18

Here is the second table:

Username | Earning

Sam | 291.2

Alex | 182.1

Here is the output I want

ID | Username | Age | Earning

2 | Sam | 21 | 291.2

3 | Alex | 18 | 182.1

Currently, my tMap outputs this:

ID | Username | Age | Earning

NULL | NULL | NULL | 291.2

NULL | NULL | NULL | 182.1

How can I go around doing so and solving this issue? Thanks.

Re: How to use tMap to combine two tables with different headers

iamabhishek — Mon, 14 May 2018 10:38:10 GMT

I believe this is what you need to setup at your tMap expressions so that you will get the exact same match for the two inputs.

All you need to do is have your match model and join model change as per your requirement.

Re: How to use tMap to combine two tables with different headers

manodwhb — Mon, 14 May 2018 10:39:22 GMT

@DarrylSSY,please do the below way in tmap.

Re: How to use tMap to combine two tables with different headers

manodwhb — Tue, 22 May 2018 08:27:46 GMT

@DarrylSSY,still do yo0ou have issue?