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
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 ANTWORTEN 4
Christina_H
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
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!

Beschriftungen