Check data from DB on tmap

Four Stars

Check data from DB on tmap

I have a question (look the attached image).

In the same DB i have 3 tables: lar, Base_Address, Base_Country.

The job that I create have "lar" table as input, a tMap and "Base_Address" table as output. Goal is to migrate data to the new structure.

The problem is that the output table ("Base_Address") have more fields, for example country, and I need to keep this data from Base_Country table. I can obtain the value of country searching it into Base_Country table with city parameter.

Target is to fill province, city (both from "lar") and country of Base_Address table, how can i do that?

 


Accepted Solutions
Community Manager

Re: Check data from DB on tmap

Hi
You need to do an inner join between lar and Base_Country table on tMap based on city column to get the country value from Base_Country table. The job looks like:
tmysqlinput(lar)--main--tMap---....
                                       |
                                 lookup
                                       |
                     tmysqlinput(Base_Country )
Regards
Shong

----------------------------------------------------------
Talend | Data Agility for Modern Business

All Replies
Community Manager

Re: Check data from DB on tmap

Hi
You need to do an inner join between lar and Base_Country table on tMap based on city column to get the country value from Base_Country table. The job looks like:
tmysqlinput(lar)--main--tMap---....
                                       |
                                 lookup
                                       |
                     tmysqlinput(Base_Country )
Regards
Shong

----------------------------------------------------------
Talend | Data Agility for Modern Business

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch