Several sheets in one Excel file

[pawe84]

Hi everyone.

I'm optimizing this following job which creates several sheets in one excel file in order to reduce components.

The current workflow is:

Sheet1: create headline -> query data -> append data to sheet1 then

Sheet2: create headline -> query data -> append data to sheet2 etc.

Now in step1 I wanted to use tReplicate in order to create the column headlines.

The problem now "Sheet1" will be overwritten although I set the "append data" option.

How to solve that problem?

Thanks for any hints.

[Anonymous]

Hi

Cache the data in memory , read the data in next subjob and append it to existing file, this ensures the execution order of job. eg:

tPrejob--oncomponentok--tFixedFlowInput--main-tReplicate --tFileOutputExcel1

--tHashOutput

|onsubjobok

tHashInput--main--tFileOutputExcel2

Hope it helps you!

Regards

Shong