Pass input variables to iterative macro type that has dynamic input tool

[nshah48]

My workflow has iterative macro and I need to pass the table name and column name to it which can get replaced in the dynamic input tool to run for all inputs. As soon as I include the control parameter, the macro changes from iterative to batch type. Has anyone done a workaround to pass values to a iterative type of a macro. Need help.

[AkimasaKajitani]

Batch Macro will work well in this case, because Batch Macro iterate by rows of Control Parameter.

Normally, we use the Batch Macro for reading multiple files.

If there is a reason why you still need Iterative Macro, please let me know. You may need a different approach.

[nshah48]

My macro has a WaitASecond macro where I want the macro to wait for a 15 minutes before it iterates to go back and check if all the tables are updated for the day. Currently I want it to iterate 5 times. This is reason why I have as an iterative macro and not batch.

[AkimasaKajitani · Accepted solution]

Hi @nshah48 

I understood that what you are saying is as follows.

1.Read 5 tables

2.Wait 15 minutes

3.Repeat 1 and 2

You have to use iterative macro and batch macro.

No1 can be created with Batch Macro.

No2 and 3 can be created with Iterative Macro.

I made test workflow. Please refer it.

Batch Macro :  This macro reads the file by Control Parameter.

Iterative Macro : This macro contains the Batch Macro. 

Workflow:

Result : 

Wait a Seconds setting is 5 sec.

I prepared 2 files for reading.

[nshah48]

Thank you very much! It worked.