How to use tMap to combine two tables with different headers

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.

Nine 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.

 

Thirteen 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)
Thirteen Stars

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

@DarrylSSY,still do yo0ou have issue?

Manohar B

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.