Setting timing delay within the workflow

[lmaughan]

I am working on an Alteryx process that I want to output different parts of the process to a single Excel file with multiple tabs.  Occasionally I run into timing issues where a tab can not be written to because of file locking issues.  I want to get around this issue by inserting a timing loop that will delay the process run for X number of seconds before continuing to the next step.

Is there an Alteryx tool that has this functionality?

Thanks in advance.

[jastamme]

Is not the most elegant solution but this has also always worked for me... Just use Control Containers for each tabpage you want to produce and make sure you link each control container. it will process the first control container and then only moves to the next control container once it has finished with anything inside the previous control container.  (The link Ed Phelps provided above was where i learned all the solutions on this a few months ago ;) )

[EdP]

@JPSeagull 

The Crew_DelayASecond does a single pause for the data stream rather than a pause between each record (as WaitASecond does), which is generally what we want.

The page below goes into options for writing multiple sheets of an Excel file.  I agree with @jastamme that linked Control Containers are the best starting point.  But in some environments, a delay may still be needed if the environment has background file replication or virus scanning active that opens the file after Designer finishes writing a sheet. In those environments, the pause will give the background process time to complete.

• https://knowledge.alteryx.com/index/s/article/Error-writing-Excel-file-to-Shared-Drive

[MRapp]

The CReW macro did the trick for me! Thank you for highlighting that one.