Saving file to share folder after processing

[OksanaBezpyata]

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

[TheOC]

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...

[echuong1]

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]

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]

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/