We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Paste data into Template file (Multiple columns)

Dhilip_Kumar
8 - Asteroid

Hi,

 

I need a workflow to copy the data from the input file and pasted into appropriate columns on Template file. I have attached my Input, Template and Expected Result for your reference, Please help me..

 

 

Thanks

Dhilip

3 REPLIES 3
CoG
14 - Magnetar

It sounds like you want to use the "Output to Range" functionality in the output tool. If you are wanting the template file to be created with running the workflow, check out this article:

https://community.alteryx.com/t5/Engine-Works/Saving-Time-With-Advanced-Excel-Outputs/ba-p/991346

 

If you just want a workflow that outputs to the template, I am attaching a sample of what that could look like.

 

Dhilip_Kumar
8 - Asteroid

Thank you @CoG . I have tried your workflow but I did not get expected result as I mentioned. Template table are not there on the output file and also we are unable to make formula in Alteryx since it will change on the template.

CoG
14 - Magnetar

Unfortunately, I have not had success using "Output to Range" if a formula is within the range (even though you can theoretically skip over columns). There may be a way to do this that I do not know, but here is a sample workflow that should do what you're looking for, just make sure that the template file is in the same file location as the input file and is labeled "Template". If that changes, you will need to rework the workflow. Of note, this will only work for the first two columns, although the process of adding columns for Product C & D should be clear.

Labels
Top Solution Authors