How to consolidate multiple Excel files in Centerprise?

Support Queries Astera Centerprise
1

I have multiple Excel workbooks which I want to consolidate into one Excel file as different worksheets.

File 1: A

File 2: B

File 3: C

Output File: has 3 worksheets A, B and C

Is there a way I can do it using the Excel destination object in Astera Centerprise? I’m using version 8 of the product.

2

If you know what the layout of all those files will be, you can create a separate dataflow for each file and try appending that data in the same file (using the checkbox ‘Append to File (if Exists)’) with worksheet named as . All those flows can be called in one workflow where the destination file path will be the same for all those flows.