We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Output file created during the workflow on gallery

Frndly
7 - Meteor

I have a workflow on gallery that uses a script to unzip a docx, it then modifies document.xml with required data, and after that it uses another script to zip it up into docx. 

The issue I'm having is that since it's not being created by any kind of output tool, final output.docx is not being detected by the workflow as an output file, so it's not being output on the gallery. What can I do to take a file in the same directory that the flow is in and output it?

3 REPLIES 3
jrlindem
11 - Bolide

I'm not sure i'm completely following your explanation, but would it make sense to break those steps down and actually write the file(s) to a location between each step so that it does, in fact, write an intermediate file to reference?

 

Using the dynamic "temp" path and temp functions you can pretty easily write to the Gallery's (or your own) default temp location using \%temp%\ as the filepath and then you can recall that using the function [Engine.TempFilePath] to dynamically call that path back without having to know what it is; given the different environments.

 

For example:

  • I can write a file to this location:  \%temp%\filename.xlsx|||sheetname
  • And then I can recall it, with a formula such as: [Engine.TempFilePath] + "filename.xlsx|||sheetname"

 

Hope that helps!

Frndly
7 - Meteor

Solved this myself via blob I/O

The issue I was having is that my final output was being created by running a script via run command tool, it wasn't created by any of the tools within the workflow directly. The fix was to capture output file via blob input and just copy it into the same directory, and this counted as output being created by the workflow, so it could be downloaded on gallery

 

 




jrlindem
11 - Bolide

Nicely done!  Yes, that approach is a good one too.  For whatever the reason I tend to default to the run command tool instead of blob's but your solution is a good one too!  Cheers and happy Alteryx'ing.

Labels
Top Solution Authors