Render tool is overwriting output data files in same file

[videet]

I have 3 output data and 1 render tool outputting in same excel workbook but render tool is overwriting that.

I used block untill toll still same issue.

Any suggestion?

[mceleavey]

Hi @videet ,

that's correct, if you have three outputs rendering to the same workbook then they will each overwrite the the existing one. You need to use a formula tool to determine which sheet you wish to write to then use the render tool to output to a specific file:

Then group the outputs into separate reports using the filename you just created as the group:

NOTE: You can't specify the sheet (|||Sheet) in the render tool, so you would need to either write to different workbooks or use the same method but using the output tool, rather than render.

Hope this helps.

M.

[atcodedog05]

Hi @videet 

As suggested in the previous post link  you can try using CReW Labelled Block Until Done. It is different from block until done. CReW Labelled Block Until Done waits for each branch to complete execution before going to next and might work for your scenario.

Let me know if this works or even if it doesnt work.

[videet]

@mceleavey ,

Added formula tool and used group data into option but getting error

Error: Designer x64: The Designer x64 reported: InboundNamedPipe GetOverlappedResult: The pipe has been ended.

[mceleavey]

Hi @videet ,

if you are trying to write out to the same workbook then you will get this error. You can't write multiple steams to the same sheet using the render tool.

If you are writing to the same sheet, there's no need to group, you just need to put multiple tables on to the layout and write out the layout to a workbook.

If you need to write to multiple sheets or multiple workbooks you'll need to use the output tool.