Check data from DB on tmap

[Anonymous]

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?

[Anonymous · Accepted solution]

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