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! 

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels