Author
Topic: How to Combine Excel Workbook together With tUnite Component in Talend (Read 54 times)

Sharing this guys to you... Tutorial : How to Combine Excel Workbook together With tUnite Component in Talend

In this scenario we are combining several excel workbook or sheets inside the workbook by using tUnite component .

There are two xlsx files one contain the data of France countries with 2 rows and another file contains the data of Mexico countries with 3 rows .tUnite component will merge both the files and get the data of both the countries with output containing 5 rows.

This job will read both the files from tFileInputExcel.

Combine the files with tUnite component.

tUnite component is used to merge data from various sources, based on a common schema. For the tUnite component you need to match the schema.

This is the Excel workbook consisting of different sheets France.xlsx,Mexico.xlsx.

Drag and drop the tFileInputExcel ,tUnite and tLogRow component from the palette.Connect each component as shown in the below screenshot.

Open the component properties of France[tFileInputExcel_1] and Mexico[tFileInputExcel_2].In both tFileInputExcel do the same process.Tick the box of Read excel 2007 file format.In the File name/Stream tab provide the path of the file where you have stored the file.To apply header to each sheet tick the box of Affect each sheet(header&footer).Tick the checkbox of Die on error so that if there is any error while processing the file then it will stop the job.

Open the component properties of tUnite .Here provide the same schema of France country .Simply drag and drop the schema.

In the Basic settings view of tLogRow, select the Basic option or tou can select Table option to display properly the output values.

Run the job.Your output will look like below containing the data of both the countries France and Mexico with total 5 rows.

Posting Disclaimer: Any individual may post a message in this forum and may do so anonymously. Therefore, the sole author is exclusively and entirely responsible for all opinions in that message. They do not represent the official opinions of Techronnati, its administrators or moderators or the Techronnati Management. Techronnati is merely acting as an impartial conduit for constitutionally protected free speech and is not responsible and will not be held liable for the content of such messages. All images and service logos are trademarks of their respective owners.