In this case, use the “Iterate table” action in table “maxdate”. The “Iterate table” action is similar to “Iterate” because it also can assign the parameter(s) of the called module with column values. However, it also can send a dataset into the iterated module.
Make the following changes in your workflow:
- Remove the “Call” action in table “toDB”
- Replace the “Iterate” action in table “maxdate” with the “Iterate table” action in which:
- Assign the parameter of the final module with column [EndInterview]
- Choose table “toDB” as the table to pass to the iterated module
When executed, in the final module the parameter (there is a parameter there, right?) will be assigned with the value from column [EndInterview] and the “Input” action will obtain the final dataset from the “toDB” table.