Output from Alteryx gallery to another flows inside the gallery

[ahmad]

Dear all , 

I have a big work flow with multi cases inside it , I separated the flows to be 5 flows these flows have a common output retrieve the data from the data ware house , I want to run the flow that retrieve the data from the data ware house first and on the server and take this output to the other 5 flows . 

Is this doable on apteryx gallery or not ? 

Thanks all 

regards  

[JagdeeshN]

Hi @ahmad 

First where is this output from the data warehouse save? It is as a data stream or a file?.

One way of ensuring sequential execution is using the different 'runner'  tools within the Crew Macro Pack.

Please check them out at the below link:-

http://www.chaosreignswithin.com/p/macros.html

Best,

Jagdeesh

[ahmad]

Thanks Jagdeesh for your reply , 

can i make the output saved on the gallery or not ? 

[JagdeeshN · Accepted solution]

@ahmad 

You have 2 different ways in Alteryx:-

1. Convert your workflow into an analytical app. This way you can output a temp file to in the working directory of the workflow. This can be done using relative paths.  Analytical apps give you access to the interface designer menu, where you can select the output files to display in settings as shown below:-

2. You can use the render tool. This also helps create a temp file that can be displayed/downloaded from the server. With this approach you can retain your workflow as a yxmd.

https://community.alteryx.com/t5/Alteryx-Server-Discussions/Modify-existing-Excel-file-with-a-Pivot-...

Hope this helps.

Best,

Jagdeesh

[ahmad]

@JagdeeshN  Thanks so much it's helped me so much