Saving Output to an excel using output tool rather than render

Question

I need to output my data into multiple template files based on column called company codes. This template has first 2 sheets with formatting and formulas. With the help of blob input and blob output tools I could able generate multiple templates based on the company codes column. (A template.xlsx, B Template.xlsx, C Template.xlsx)

Then my data needs to be formatted, which was done using Table and layout tools, I want to output this data into a A,B and template files with sheet name called "check 1 table" using render tool my results are getting overwritten. which means missing first 2 sheets of template.

Tried Output path tool but it will give xml code as results.

IS there any way to output the data into without change in template.

ShravaniChanda · Answer

ShravaniChanda · Answer

Hey Phill,

I referred to your link, but it may not help because my results are coming out of layout tool.

.

Maskell_Rascal · Answer

Hey @ShravaniChanda

So as you've discovered, the problem with the Render Tool is that it will always overwrite the file in question.

To get around this problem, I would try the method I outlined in another post about using a template file.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Outputting-multiple-excel-files-using-different-cuts-of-raw-data/m-p/596335#M132786

Cheers!

Phil