Command stop Macro

Question

Hi everyone,

I am trying to create one workflow that has an output in the middle of the workflow, which later on has that output as an input. I need to wait until the output has loaded before the input starts loading otherwise the numbers calculated from the excel file are not being brought in correctly. Is there a macro to command an input to stop until the output has loaded so I can include all detail in one workflow?

Thanks,

hargquin · Answer

I do not believe that would be a solution as I need to pull in calculated numbers from an embedded excel AFTER alteryx provides inputs to start the calculations in excel. A block until done solution won't be sufficient as I am pulling different cells from the embedded excel file. Does that make sense? I've tried to provide an example but know the calculation is much more complex and I need updated output numbers if the input numbers change

Excel example.xlsx

Qiu · Answer

@hargquin 
This should be the one you are looking for.