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
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...
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.
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
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://intersectionsandoverlaps.wordpress.com/2019/09/27/alteryx-excel-templates-with-blob-tools/