Copy /Paste the line items in Pre existing Template

[Jaganmohan]

Hi Team,

I have a pre existing template (xlsx file)  with me.

Everyday  i need to fill that pre existing template based on the sample input file...Could you please assist me on how to copy and paste the line items from Sample input file to template.

Please find attached sample input file and Template - Thanks in advance. 

[Luke_C]

Hi @Jaganmohan 

Take a look at the solution to this post. In short, for templates typically you want to keep the template as-is, copy it, then output the data to the copy

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Clearing-Data-in-Template-before-Overw...

[Jaganmohan]

Hi Luke,

I am unable to open the solved solution .yzxp Alteryx workflow - Could you please help me out with my query - Thanks.

[Luke_C]

Hi @Jaganmohan 

What's the error? There are a number of posts on this topic in the community. Here's another approach using blob tools.

[Jaganmohan]

Hi - Is it possible to implement the same in 2019 version  and could you please provide me the sample workflow related to my query. (using 2019 version) - Thanks in advance.

[Luke_C]

Hi @Jaganmohan 

Refer to this post on how to change the version

https://community.alteryx.com/t5/Engine-Works/Making-Workflows-Apps-amp-Macros-Backwards-Compatible/...