Block Until Done

[Madihah_29]

Hi all!
I would like to produce a report in .xlsx first like in green color. When the report is done, then the input will take the previously produced output in turquoise color.

Does anyone know how can I do that? Many thanks for your idea!

[sparksun]

It's easy to use Control Container tool to achieve that.

[Madihah_29]

Is it possible to do because I join it after that? Also, how can I have the tool? Because it didnt appear.

[CoG]

Control Containers are new to version 2023. As the title of your post mentions, if you do not have access to the newer versions, then you will need to use the block until done tool with the AMP engine turned off. To my knowledge, Having the join afterwards shouldn't affect anything.

[caltang]

You are joining a report to a non-report, so are you sure that is what you intend to do? Because the report tool won't generate data per se on Alteryx, it just gets your data and exports it a report format (a la PDF, PPT, Word, XLSX). If you are joining the data from XLSX (via report), then I think it should be fine. Other files may just result in the "result" of the format in your Join (assuming you are joining via record position than a key). 

On your topic of doing things sequentially, I would recommend using an Analytic App, then chain it to achieve your result. That is much easier to control. Otherwise, if you are planning to upgrade to v2023, then Control Containers is the way to go.