Alteryx Designer Desktop Discussions

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

Variable output location in excel file

stellar
5 - Atom

Hello Designers,

 

I hope this is not a repeat as I searched for it pretty hard but maybe I am using wrong keywords.  I have a headcount report that I am automating.  Every month this report is run and certain fields are added into the main report.  Is there any way to have a variable output location in an excel file that will change each month. 

 

So for example using the image below I need a certain set of data to be sent into DJ11 for March.  For April I need the report to send the data into cell DK11, June into cell DL11 etc.  So basically is there a way that the output can change based on which month I run it or possibly to just shift one cell each time it is run?

1 REPLY 1
Qiu
21 - Polaris
21 - Polaris

@stellar 
I can not really send the date to specific cell, but I tried to read all then update the specific cell then write it back.

0318-stellar.PNG

Labels