The tUnite component takes one or more inputs and outputs a data flow in the style of a SQL UNION.. If using Excel sources, and configured accordingly, the tUnite component will also output each sheet in the workbook in the data flow.
These Excel workbooks contain business contacts spread across two regions: BusinessContacts_West.xlsx and BusinessContacts_East.xlsx. Additionally, there are sheets for each fiscal year in the workbook.
|An Excel Workbook with Several Sheets|
|Configuration for tFileInputExcel|
"Header 1" is important so that the headers repeated on each sheet aren't also repeated in the output data flow and mixed with the data.
The two workbooks are configured similarly. Each workbook's main data flow is sent to a tUnite component which sends its output to a tLogRow (for demonstration purposes).
|Sample tUnite Job|
|Running the tUnite Example|