Scenario: To populate data on main table from 2 lookup with the same column name, but having different data.

Highlighted
Seven Stars

Scenario: To populate data on main table from 2 lookup with the same column name, but having different data.

Hello,

 

I'm thinking if how can I map this scenario:

 

2 lookup tables with almost the same column but have different data 

(There's only 1 column that is not identical and that's contain the Main Office Name of both tables depends on the Branch office name)

 

1 main table that should have the data from 2 lookup tables

 

I should have the values of the data from those 2 lookup tables and what I can only link is the Office Owner and Office Admin.

 

The other values like city, state, zipcode,etc how can I populate it on the right way? I can't have like row1.city,row2.city on CITY column on main table. I should have the right data and being populated to each row. Is tmap will not work on this or is there aby other alternative way to do this?

 

Thanks for any suggestion or maybe a solution on this.


Accepted Solutions
Seven Stars

Re: Scenario: To populate data on main table from 2 lookup with the same column name, but having different data.

Thanks @nikhilthampi for paying attention on this post and apologize as I forgot to update this, I already resoolved this by using tmysqlrow  and place the join query of the 2 tables there, then link it as a look up (tmysqlinput) to provide the right output.


All Replies
Employee

Re: Scenario: To populate data on main table from 2 lookup with the same column name, but having different data.

Hi,

 

    Could you please share sample records for all 3 tables along with join conditions for better understanding of the problem? Sample of expected output also will be really helpful. You can also add the screenshots of current tmap details for detailed analysis.

 

Warm Regards,

 

Nikhil Thampi

Seven Stars

Re: Scenario: To populate data on main table from 2 lookup with the same column name, but having different data.

Thanks @nikhilthampi for paying attention on this post and apologize as I forgot to update this, I already resoolved this by using tmysqlrow  and place the join query of the 2 tables there, then link it as a look up (tmysqlinput) to provide the right output.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

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

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch