Control run order of Directory tool

[bsharbo]

Hello all. I have an extremely simple requirement that is proving to be extremely difficult in AlterYX and would like some advice.

Basically I need to run a direcctory tool to find a File in a given directory.   I then need to COPY some of the files into a DIFFERENT directory, and then once again run the directory tool on the NEW directory to determine how many files made it.   (This is simply an easy example of needing to use the directory tool twice and needing to control for when they run).

However Alteryx seems to be running the second directory tool whenever it feels like, and I can't find a way to control the run-time of the second Directory tool.  How do you control workflow run time In AlterYX  like this?

Putting the two workflows into macro's didn't help

[JordanB]

Hi,

Could you have these two directory tools saved as two different workflows? You could then use the events tab to set up a 'Run command' event to set off the second workflow (with the second directory tool) once the first directory tool has run and copied the files to the new directory? There is also a paramter within the run command set up to set a time delay between workflow runs (see screenshot below)

This community article explains the 'Run command' process very well: http://community.alteryx.com/t5/Alteryx-Knowledge-Base/How-to-Use-One-Module-to-Execute-Another-Modu...

Let me know if this is not exactly what you were looking for.

Best,

Jordan Barker

Client Service Representative

[danielbrun2]

Hi,

Have you tried with the "Block Until Done". Could you maybe take a screenshot of the flow.

Best regards,

Daniel

[AdamR_AYX · Accepted solution]

The runner macros in my CReW macro pack are another way to control order of tools.

Check out my description of them here http://www.chaosreignswithin.com/2014/09/blog-macro-pack-2014-q3-release.html

and the latest version can be downloaded from links here http://community.alteryx.com/t5/Engine-Works-Blog/Crew-Macro-Pack-2015-Q3-Release/ba-p/5423