Wait Function/Macro

[ebuch]

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 

[LordNeilLord · Accepted solution]

Hey @ebuch

As part of the standard tool set you have "block until done" this should be sufficient to achieve what you need

[jdunkerley79 · Accepted solution]

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.

[ebuch]

Thank you :)

[tmahmo15]

How can I have Wait macro configured and used?

[CAJay]

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)

[prpatel]

Hi @CAJay 

How did you get the R-tool? I do not see it as a tool

Thanks.

-prpatel

[CAJay]

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/how-to-install-R-tool/td-p/433761 

Please check out this article

Thank you

[prpatel]

Thanks @CAJay Looks like I need the Predictive Tools package.

Do I need to pay for that package?