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.
SOLVED

Excel output to existing template

AlteryxPrime666
7 - Meteor

Hello great minds, 

 

I have a workflow that produces table with 10 fields. (Value 1, Value 2, Value 3 etc.) and N amount of rows. I also have an excel called "Calculator", where cells B4:W(N) contains calculations with values of Alteryx output. Is it possible to output the table from Alteryx to the Calculator Excel directly to fields B15:W25, so that I wouldn't have to manually copy the values from Alteryx output to Excel?

 

Thanks a lot in advance!

2 REPLIES 2
alexnajm
18 - Pollux
18 - Pollux

Yes you can - when you configure the Output Data tool to write out to the Excel file, you'll have the option to insert the range. Here, I would specify B4 and then W:1000 - this is just a high number to make sure it'll accommodate as many rows as needed.

alexnajm_0-1677675249512.png

 

AlteryxPrime666
7 - Meteor

Thanks a lot! 

Labels
Top Solution Authors