Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

.\ Saving output in same folder as workflow in xlsx.

furlonla
8 - Asteroid

Hi there,

 

Is it possible to save your output as an xlsx in the same folder as your workflow? I know it's possible to save the workflow .\outputdata.yxdb but what about in another format.

 

Thanks!

4 REPLIES 4
Emil_Kos
17 - Castor
17 - Castor

Hi,

 

you need to use [Engine.WorkflowDirectory] command in order to make it work.

 

I have prepared a workflow for you as an example.

furlonla
8 - Asteroid

Hi Emil, 

 

Thanks for this!

 

furlonla_0-1611135600757.png

Is there anyway to have this not linked to the users desktop?

 

Thanks,

Laura

 

Emil_Kos
17 - Castor
17 - Castor

Hi,

 

This is the true location. You are creating the output file location + file name+Sheet name in this formula tool.

 

Emil_Kos_0-1611135704062.png

The top part of this configuration will not be used as at the bottom we are replacing the location by the output filename column. 

 

Emil_Kos_1-1611135769097.png

 

 

furlonla
8 - Asteroid

Thanks, this is really clear!

Labels
Top Solution Authors