Block until done runs after each iteration

Paridhi_Agrawal

Hi ,

I have a workflow that has batch macro that generates around 10 PDFs.

and then I have a macro to send email attaching those 10 PDFs.

Issue is when I used Block until Done tool, after every iteration (after generating every PDF), it hits to email macro.

But I want it to hit the email macro once all Pdfs are generated.

Any trick or solution will be highly appreciated.

Thanks in advance!

image.png

Iterative Macro

Accepted answers

danilang

Hi @Paridhi_Agrawal

Email tools always run after all other tools have finished running.

Email tools will also send an email for each record in the input dataset. If you want to have the email sent just once with all the attachments, use a sample tool to select only the first record in dataset. If the attachments are always maned the same, your job is done. If the attachments that you send are dynamic, you'll have to have a way to change the attachments in the email tool. You can crosstab the list of attachments and use each of the resulting fields as attachment fields.

Dan

All comments

alexnajm

Do you have AMP Engine turned on? I would turn it off if so - it can make Block Until done tools moot

Paridhi_Agrawal

@alexnajm , its off

alexnajm

@Paridhi_Agrawal thanks for confirming - I would also confirm that for the macro just to be safe!

Do you have 2023.1 or later? If so, I would recommend Control Containers instead - yes, AMP Engine has to be turned on but it's a more robust way to control the flow of what executes first, second, etc.

Control Container Tool (alteryx.com)

Control Containers: Take Control of Your Workflow - Alteryx Community

danilang

Hi @Paridhi_Agrawal

Email tools always run after all other tools have finished running.

Dan

apathetichell

Why do you have the block until done tool?

Paridhi_Agrawal

Thanks everyone, I have modified my workflow so that only one record will be inputted into email tool. and it works.

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167