How to use tMap to combine two tables with different headers

[Anonymous]

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.

[iamabhishek]

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.

[manodwhb · Accepted solution]

@DarrylSSY,please do the below way in tmap.

[manodwhb]

@DarrylSSY,still do yo0ou have issue?