Output result to an excel template

[AndyHH]

Hi community!

I want to generate my calculated result into one excel template.

How could I do it? After i search in the community and still can not find one appropriate answer.

Thanks!

[atcodedog05]

Hi @AndyHH 

Can you provide a sample input dummy data and the output template.

[messi007 · Accepted solution]

@AndyHH,

Please check this post : https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Output-into-existing-excel-template/m-... 

Regards,

[AndyHH]

@messi007 wow you save my life!! Thanks !

I did not notice it was that simple, thanks a lot.

@atcodedog05 also thank you for the quick feedback!

[messi007]

@AndyHH happy to help 🙂

Regards,

[AndyHH]

Hi @messi007 , 

Sorry for bothering again, now for me is the version issue.

What I tried to use your solution and succeed is when I using V2020 of Alteryx,

However, our server only allow the version of V2019.4.8 which the output table is different from V2020.

And the one which can tick for fixed template is not there as below, can you advise another method in V2019.4.8? Many thanks!

[atcodedog05]

Hi @AndyHH 

This feature was released in 2020.1 its not available in the previous version and there is no workaround 😶

https://help.alteryx.com/release-notes/designer/designer-20201-release-notes

You try this method https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-do-I-output-to-an-Excel-templat... 

Hope this helps : )

[AndyHH]

@atcodedog05 Thanks for your reply.

And I found that I can do this with the Render tool.

Still many thanks!!