I have an iterative macro with only one input that is configured for a file template (excel)
It is acceptable that the fields in the excel sheet will change, the macro will work fine so i want to treat this input as dynamic
What i want to be always present is an additional field "Authorization" which will not be ever present in the excel sheet
So to rephrase I want to have a combination of file input (dynamic fields) and one constant text input field. The input should be like this
| n * Dynamic fields | Authorization |
| n * Dynamic values | Some data |
A simple string field, again value is irrelevant here. I want to achieve is dynamic input in macro but with this field always there
Would a Formula tool do the trick ?
The value for Authorization field is generated from outside the macro and is not to be manually inputted. It has to arrive together in the macro input with the file input fields
Have you tried using another Macro Input tool ?
I ma using this input in an iterative macro. So in the macro output for loop, I need to combine them for the next iteration to use them
If I have 2 inputs then only one will be used for the iteration input correct. Then how will I use the other one?
