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
17 - Castor
17 - Castor

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