Blob Tool on Alteryx Server

[Eswartz_5200]

I am using the Blob tool utilize an excel template for an Alteryx workflow. I have no issues with this working on the local machines. However, when I upload to the server the template is saved to a local drive and only the two excel outputs are available download on the server by the users. Is there something different in the way that the Blob tool needs to be set-up on the server vs on the local machines?  

[fmvizcaino]

Hi @Eswartz_5200 ,

Do you want the templates to be also available for download? Or do you want your outputs to use the template you just generated and then have this available for download?

Best,

Fernando Vizcaino

[Eswartz_5200]

@fmvizcaino I'm looking for the outputs to utilize the templates. I have pivot tables built out in the template that are relying on the two excel tabs being populated. The template itself does not need to be available for download.

[fmvizcaino · Accepted solution]

Got it, thanks for the clarification @Eswartz_5200 .

The issue is that, for your template to be used, the output file must be saved to the same folder where your template is located. Since you are sharing the output with the end-users, Alteryx will use a temp folder to generate the file. 

This will be an easy fix since you understand how to use the blob tools.

1. Save the output file to the same shared folder where the templates are located
2. Add a second step in each block until done tool (very similar to the one you created for the template)
   1. Load the output file just created to a blob and have a blob output generating an xlsx file
   2. This blob output will be the asset checked when you save to the Gallery

Best,

Fernando Vizcaino

[Eswartz_5200]

@fmvizcaino The solution that you provided worked as expected. Thanks! I attached a PDF of the final output just in case anyone else runs into this issue.

[fmvizcaino]

Thank you so much for sharing, @Eswartz_5200 !