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

Alteryx Designer Desktop Discussions

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

Saving file to share folder after processing

OksanaBezpyata
8 - Asteroid

Hi,

 

I have created an Analytical application in Alteryx Gallery  where the user has to insert .xlsx file from local machine. The result of the workflow is the table in Athena, but I also need Alteryx to save this processed file in share folder, could you please advise what is the most optimized way to achieve it.

 

Thank you in advance!

Oksana

4 REPLIES 4
TheOC
15 - Aurora
15 - Aurora

Hi @OksanaBezpyata 

If im not misunderstanding, could you potentially have the analytical application saved within the shared drive, and then use ./ as your saving directory to save the output where the workflow is saved.

Here's some more detail, if this works for your application
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Save-output-in-the-same-folder-your-wo...


Bulien
echuong1
Alteryx Alumni (Retired)

You can have an output data tool write to a file type of your choice (excel). The file folder location would be on your shared drive.

OksanaBezpyata
8 - Asteroid

Hi @TheOC

 

Thank you very much for your reply. 

 

Unfortunately, I can't save the analytical application on share drive.

 

Let me describe in more details: 

 

The analytical application should be run from Alteryx Gallery (it is stored in the collection) -> the user should upload the file from local machine to the application when running the application -> the same input file, which was uploaded by the user to the application (without any changes) should be loaded to share drive (to store all processed files for history) -> output of workflow should be loaded to Athena table ( I don't need the output of the workflow to be loaded to the share drive)

 

Best regards,

Oksana

echuong1
Alteryx Alumni (Retired)

Ah okay, that makes more sense.

 

You can create a copy of your excel file and output it to the shared drive with the blob input and blob output tools.

 

See this link for more information:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Write-multiple-excel-files-using-a-tem...

https://intersectionsandoverlaps.wordpress.com/2019/09/27/alteryx-excel-templates-with-blob-tools/

Labels