Input Data - Output Data and run again utilizing result set

Question

This seems pretty straight forward but I can't seem to find my way to an answer but what is the best layout/approach/controls for the following workflow:

I have an input data control that queries an Oracle table and an output data control that writes that result set to another Oracle table with the same columns.  But now, after that occurs, I then need to have another input data control and output data control that executes after that previous set within the same workflow.

Forgive my novice Alteryx skills here but what is the mockup/diagram for getting the following into one workflow container.

Input -> Output -> Input -> Output?  How do you connect 2 sets of input/output data as I don't see a connector available coming off the output data to essentially go from there to the next segment?

Cheers and thanks

soccertil1108 · Answer

You could possibly build a Macro to process both files. You would start by having the Actions update a Text Input. But, I believe that a macro would add a level of complexity that isn't really required unless you are very comfortable with building macros.

ITG1 · Answer

Thanks.  I was hoping there was a way to avoid recreating all those update values again since they're already present in the workflow and connecting to the other input/outputs but maybe not?

soccertil1108 · Answer

If I understand your problem correctly, the same Application prompts need to feed two input and output data flow?s If so, then simply add the second input and output to your workflow and create new actions for the Application prompts.