Hi there,

I assumed this was possible but I'm getting unexpected results. Wondering if you can point me in the right direction for confirguration.

The mission is to populate 2 tabs of an Excel workbook with different data sets. Tab 1 is currently populated with complex pricing data and it is based on a Template Workbook. That part is working great.

I now want to populate a second tab of the workbook with different data that comes from CRM. Since the data is structured differently, I want it to be on a separate tab apart from the more rigid structure of the first tab.

Currently I create the worksheet with step 1 (based on a template).

Then I have a subsequent job stream that starts with an SQL read and ends with an Excel writer task. I'm trying to "point" it to the output created by step 1, but IMAN is creating a separate file. I'm curious if this is by design or if I can configure this to work how I'm intending.

The file name for both Excel writers is a formula: "OutputPriceWorksheet" & Format(Date, "yyyyMMdd") & ".xls"

But what happens is I get two files, eg:

"OutputPriceWorksheet20220201.xls"

"OutputPriceWorksheet20220201_1.xls"

Here's how I have the second pass configured (see attachment).

Suggestions on how I can accomplish this? Anything else you need to know?

Assembly Versions:

Product Update: Product Update 1

Config Version: 4.24

DB Version: 4.20