Four Stars

How to use tMap to combine two tables with different headers

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.

3 REPLIES
Six Stars

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

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.

tMap-TC1.JPG

 

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

 

Eleven Stars

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

@DarrylSSY,please do the below way in tmap.Untitled.png

Manohar B
Tags (1)
Eleven Stars

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

@DarrylSSY,still do yo0ou have issue?

Manohar B