Need help in merging three excel sheets in one

One Star

Need help in merging three excel sheets in one

I need to merge the data from three excel sheets in one db Table. The structure that I am following is like this
Excel File 1 ---------->
Excel File 2 ----------> tMap -----> db table
Excel File 3 ----------->
but this is not merging the data... tMap is adding the sheet data in different db rows. All excel files are having same number of rows. How can i merge the data in a single row made up of three different excel file rows?
Please help me solve this problem.
Thanks
Community Manager

Re: Need help in merging three excel sheets in one

Hi
I think it is a simple request. Can you show us an example? I will create a demo job for you.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Need help in merging three excel sheets in one

Yes it seem to be a simple job but I got stuck in it as data is multiplied with rows present in each excel sheet. For example if i have 30 rows each in each excel sheet then data was like 30*30*30. I tried to use tUnite but didnt solve this problem.
Here is an example:
I have a one big employee table in db whose data is coming from three sheets present in one xls file. Each employee data is divided according to categories in the separate sheets where each row of each sheet is representing one employee data.
Like
sheet1: firstname | lastname | email -----> (30 entries)
sheet2: designation | salary -----> (30 entries)
sheet3: street | houseNumber | city | address1 | address2 -----> (30 entries)
and the end result should be like this:
firstname | lastname | email | designation | salary | street | houseNumber | city | address1 | address2 ---> (merged 30 entries of db)
Please help me how to merge the data in one row of db?
Thanks for your help.
Community Manager

Re: Need help in merging three excel sheets in one

Hi
Here is a demo job, please see my screenshots.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Need help in merging three excel sheets in one

Can anybody please help me how to the following scenerio?

tFileInputMSPositional -------> tExtractPositionalFields ---------->
-------> tExtractPositionalFields ----------> tMap
-------> tExtractPositionalFields ---------->
I am not been able to merge these three extracted fields in one tMap Smiley Sad
Any help be appreciated. Thansk
Community Manager

Re: Need help in merging three excel sheets in one

Hi
You are not allowed to create a cycle flow in a job. So you have to output the records to temp file or memory first, for example:
tFileInputMSPositional -------> tExtractPositionalFields ---------->tFileOutputDelimited_1
-------> tExtractPositionalFields ---------->tFileOutputDelimited_2
-------> tExtractPositionalFields ---------->tFileOutputDelimited_3
|
onsubjobok
|
tFileInputDelimited_1---->tMap
tFileInputDelimited_1----
tFileInputDelimited_1----
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
Four Stars

Re: Need help in merging three excel sheets in one

Hi I Have 50 Excel sheets of similar data; and now I need to move all these 50 Excel sheets data into a single excel sheet. I used
1.tFileList, 2.tFileInputExcel, 3.tUnite/tMap. But still I couldn't get the job clear. The problem is I couldn't get the schema in tFileInputExcel when checked.
Can anyone suggest me the clear full solved view of solving this problem? I tried so much,but still my job is incomplete. can anyone help me please.
Thanks in pre-hand.