Colleagues
I am not sure if there is a solution for this, but here goes.
I notice that Alteryx inputs all external sources first then begins processing.
Currently, 34 inputs are occurring simultaneously, then processing through...
I don't want that.
I want 22 sources input first...then process ..then exporting data to a workbook...then after I have a python script open and refresh this workbook....then input these sheets from this workbook....then process some more exporting to 4 workbooks.
Any ideas?
Hi @JoeChia
Just a thought why not split into 2 workflows instead so that one completes and after that other one starts.
As i know you cant sequence inputs read. If it was in the further process for the flow you could use Block until done.
https://help.alteryx.com/current/designer/block-until-done-tool
Hi @JoeChia, Alteryx natively doesn't have an orchestrator layer to control the sequence of events within the workflow. That being said, you could explore the approach suggested by @atcodedog05, or maybe split your process into two different workflows and call the 2nd once the 1st completes. This is also known as Chained workflows in Alteryx: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Chaining/td-p/435390. You could also use the Runner macro (also mentioned in the link) available within the Crew Macros to sequentially run pieces of the workflow.
Hi @JoeChia
I agree with @AbhilashR idea of creating chained app. You create two apps for two workflow with no input.
Here is an example.
Apps-1
on clicking continue it will trigger next app.
App-1 workflow: and also writes to file
App-2
App-2 workflow: is reading data written by app-1
This is a neat approach which might help your task.
Here is a interactive lesson on chaining apps https://community.alteryx.com/t5/Interactive-Lessons/Chaining-Analytic-Apps/ta-p/243120
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍