Hi,
I have an issue when making a lot of different output into excel on the same time, it makes an "Error" due to the document being used in another process.
I therefore need to have some kind of "Wait function" - I have seen there is the following discussion: https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Wait-Pause-Between-Processing-Records/ta-p/3...
But I since my PC is highly restricted for downloads, I can only download Alteryx files directly from this website.
Do any of you have this macro mentioned or another macro you use for the same purposes?
Best regards,
Erik
Solved! Go to Solution.
Hey @ebuch
As part of the standard tool set you have "block until done" this should be sufficient to achieve what you need
One option is to use the Block Until Done tool.
This tool only sends data to one output at a time allowing you to complete writing the first stream before processing the second.
Thank you :)
How can I have Wait macro configured and used?
solution which I could think of using R tool, on Alteryx wait issue please find below
Basically 2 tools are being used to arrive at the solution –
Block until Done and R language Tool
Under Block until done tool
1st Stage add R Language tool and run below script – (”30” in script means 30 seconds , which can be changed accordingly)
2nd Stage add the relevant tool needed as per your requirement
R Script below
testit <- function(x)
{
p1 <- proc.time()
Sys.sleep(x)
proc.time() - p1 # The cpu usage should be negligible
}
testit(30)
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/how-to-install-R-tool/td-p/433761
Please check out this article
Thank you