Join the Inspire AMA with Joshua Burkhow, March 31-April 4. Ask, share, and connect with the Alteryx community!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Dynamic input for macro

fardeen9983
8 - Asteroid

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 valuesSome data
6 REPLIES 6
Jean-Balteryx
16 - Nebula
16 - Nebula

Hi @fardeen9983 ,

 

What values should the new field Authorization contain ?

fardeen9983
8 - Asteroid

A simple string field, again value is irrelevant here. I want to achieve is dynamic input in macro but with this field always there

Jean-Balteryx
16 - Nebula
16 - Nebula

Would a Formula tool do the trick ?

 

Capture d’écran 2021-01-25 à 08.50.05.png

fardeen9983
8 - Asteroid

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

Jean-Balteryx
16 - Nebula
16 - Nebula

Have you tried using another Macro Input tool ?

fardeen9983
8 - Asteroid

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?

Labels
Top Solution Authors