Sequencing Inputs

Question

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?

atcodedog05 · Answer

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 😀👍

chained.zip

AbhilashR · Answer

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.

atcodedog05 · Answer

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