Combine two datasets into one excel workbook
Situation:
The following process flows produces 2 separate data-sets. Where would I implement the solution below (excel as a db schema) in order to combine both data-sets into 1 excel workbook with each data-set on separate worksheets.
-
Solution:
As per our investigation based on your initial query you cannot use excel as a database schema on target to create excel file. Microsoft Driver that is used to treat excel as a database does not support at target. You can only use excel as a database to read the data on the source
In your process flow design you are using "Excel Database Source" just after your mapping which is incorrect because a data mapping output expects a target activity.
To implement your scenario we would recommend not to use excel as a database schema at target. Instead create two excel schemas for sheet1 and sheet2 data. Also create an Excel file target activity. Now load both the Excel schemas on target in your data mapping and complete your mapping. The data mapper now has two target schemas so it will be generating two output streams when you will use in process flow. In your process flow after data mapping activity use both the excel schemas followed by the same excel file target. Change the append mode to "true" in both the file target activities.
0 -
I have implemented this, but output_1 and output_2 end up append in the same spreadsheet tab; I thought they would end up on separate tabs?
0 -
Make sure the "Sheet Name" field of the two target schemas are different
0
Post is closed for comments.
Comments
3 comments