Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

Saving Information from workflow to an excel sheet

Eneida33
7 - Meteor

Good morning,

 

I have created a workflow.

I want to save the information from the workflow every day automatically to my excel file.

I have different sheets for each day.

How can I do that?

 

Thank you!

4 REPLIES 4
Christina_H
14 - Magnetar

I do something like this by using a formula to generate the filepath including Excel sheet:

Christina_Hurrell_0-1628584779691.png

 

Then setting the output tool to use that field:

Christina_Hurrell_1-1628584869021.png

 

In my case I'm creating a new sheet each time the workflow runs, you might need to alter the configuration depending on how yours is set up.

atcodedog05
22 - Nova
22 - Nova

Hi @Eneida33 

 

Adding to @Christina_H response if your filename is fixed and only sheet name changes. You can only generate date as sheetname and configure output tool to change table name so that it only changes sheetname based on column. Refer highloghted option below.

 

atcodedog05_1-1628586423276.png

 

Hope this helps : )

 

Eneida33
7 - Meteor

Thank you Very much for your help.

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Eneida33 

If responses helps please don't forget to mark it as solution.

Cheers and have a nice day!

Labels
Top Solution Authors