Stop reading/loading Input data from second container before first container job is done.

Hello folks,

I have been trying to find a solution for my problem and I have tried generic "Block Until Done", then CReW Macros "Parallel Block Until Done" but still haven't resolved it.

So, what is the point?

Alteryx - Stop Until.JPG

As you can see from the picture, I have multiple input connections split in two containers ( 1 and 2).

Now, when I run the flow all Inputs start at the same time and this is my problem. I would like to "split" reading/loading data in two sections.

So, is it possible when I run the flow to load the data from container 1 and when it's done, then start with reading/loading the data from the second container?

Thank you in advance.

Datasets

Input

Custom Tools

Macros

Help

Dynamic Processing

Database Connection

Accepted answers

cito

Hello folks,

Sorry for the late reply since I was on vacation, but finally I found a solution based on video that @atcodedog05 shared here.

So, I did a little bit different approach but it works for now 🙂

Actually, the first step is "Text input", where I put "dummy" file/info, that one I am excluding latter and that's it.

Attached is the demo flow.

Again, thank you all for participating in this post and helping me.

block demo.yxmd

All comments

mceleavey

Hi @cito ,

This is interesting because they both run in parallel until the union. The easiest way around this is to put the second container and everything after it in a macro. Then feed the output of the first container into the macro with a block until done before the macro. This means it will load everything from the first container before proceeding to the macro, whereupon the second container will be triggered.

This is the easiest way of achieving this.

atcodedog05

Hi @cito

Its great that your are using CREW Block until done its better than normal one. Here is what you can do, you need to control input flow. Instead of using normal input tool use dynamic input tool. Layout like below.

Use CREW block until done not normal. This way you can read files in a sequence. The paths to dynamic input are passed from the text input tool.

Hope this helps 🙂

cito

Hello @mceleavey - not sure if I understood you correctly, but how did you mean to put the second container in the macro since I do not have "IN" anchors there?

Thanks.

cito

@atcodedog05- what does mean "Paths" here and how to populate it? 🙂

cito

Hello folks,

Sorry for the late reply since I was on vacation, but finally I found a solution based on video that @atcodedog05 shared here.

So, I did a little bit different approach but it works for now 🙂

Actually, the first step is "Text input", where I put "dummy" file/info, that one I am excluding latter and that's it.

Attached is the demo flow.

Again, thank you all for participating in this post and helping me.

block demo.yxmd

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335