Container Issues

[knnwndlm]

Hello,

I have two containers that have the same structure with different input sources.  The first one would get the input data from Table A and sends it a Python tool connected to the Run Command to pull data from SAP automatically.  The second one does the same thing but gets the data from Table B.  Since I can only have one instance of SAP open at a time, I would have to run one container while the other one is disabled and vice versa.  I can't use the Control Container either because there's not output from the first container to the second - hence, the no valid metadata for outgoing connection 1 error message.

I'm trying to figure out a better solution to disabling containers one at a time.  My one solution is to use the Iterative Macro, but I'm not sure how to create one that would determine when the Run Command is done in first container.  My other solution is to put a pause in between the two containers with a macro, but I'm not sure if that's the best solution.  My last solution is to incorporate some sort of Python script to do this - which I'm not sure how to approach this either.

Could you please provide some suggestions on how I can approach this for best practice?

Many thanks,

kwl

[Sparsh_Jain]

@alexnajm did the batch macro work in your case, i've the same issue where i need to run 4 different containers, one at a time and can't use control container as well for the output of first container is not using in 2nd container in my case. 

[alexnajm]

@Sparsh_Jain Yes it did! But you don’t need the output of a previous container to be the input to the subsequent container. You can still link control containers together, regardless of them being dependent on one another!