topic Re: Output from Alteryx gallery to another flows inside the gallery in Alteryx Server Discussions

Output from Alteryx gallery to another flows inside the gallery

ahmad — Thu, 14 Apr 2022 11:31:07 GMT

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

Re: Output from Alteryx gallery to another flows inside the gallery

JagdeeshN — Thu, 14 Apr 2022 12:44:09 GMT

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

Re: Output from Alteryx gallery to another flows inside the gallery

ahmad — Thu, 14 Apr 2022 12:50:27 GMT

Thanks Jagdeesh for your reply ,

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

Re: Output from Alteryx gallery to another flows inside the gallery

JagdeeshN — Thu, 14 Apr 2022 14:11:42 GMT

@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-Table-and-make-it/td-p/923607

Hope this helps.

Best,

Jagdeesh

Re: Output from Alteryx gallery to another flows inside the gallery

ahmad — Tue, 19 Apr 2022 07:14:15 GMT

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