How to iterate a same workflow with a few different parameters?

Question

I have a simple workflow, which is to get data from Table 1 on SQL server 1 and insert into Table 2 on SQL server 2.

But I have 100 tables on SQL server 1, and all of them needs to be processed into correspondent tables on SQL server 2.

I don't want to create 100 workflows.

I would like to know how to create a single workflow, and put it into a For Loop.   Each iteration, a different table name, as parameter, to be passed into the workflow to run.

How to do that in Alteryx?

Thanks in advance.

flying008 · Answer

Hi, @YipengTang

Could you please upload your wf sample or screenshot for explain the case ?

YipengTang · Answer

In the Macro, I can use dynamic input.   But how to do dynamic output data (table name can be replaced) ?  Alteryx doesn't have that option.    In the Output Data tool box, if I use "Update; insert if new", than I can specify the Key name.   These 100 tables have different key column names.   How to do that dynamically?

flying008 · Answer

Hi, @YipengTang

Maybe you can building a batch macro for this process case. then your use input + macro to get your want flow.