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!
@AndyHH,
Please check this post : https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Output-into-existing-excel-template/m-p/838641#M206248
Regards,
Hi @AndyHH
Can you provide a sample input dummy data and the output template.
@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!
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!
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-template-file/ta-p/1244
Hope this helps : )