Wait Function/Macro

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/30041

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

Macros

Accepted answers

LordNeilLord

Hey @ebuch

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

jdunkerley79

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.

All comments

LordNeilLord

Hey @ebuch

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

jdunkerley79

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

prpatel

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

Do I need to pay for that package?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703