How to create a macro input that allows different columns of input

Question

I have a macro that should allow different input types, i.e., input may have different columns based upon the macro requirement.
How can I create a macro input that takes different columns each time and shows me in the drop-down?
Can you guys help me with this?
Thank you.

Riyaz_Shaik · Answer

Could you please explain in detail, I was trying to use the transpose tool but I couldn't able to achieve it.

OTrieger · Answer

@Riyaz_Shaik

Ok, in this case you might want to use chained apps, so the first one is pulling in the headers and then next one is taking the user to the User Interface to select the headers.

Riyaz_Shaik · Answer

I was trying to create a macro that takes input and performs some actions, these actions are performed on the selected columns based on the selections made through dropdown. So I need to get dynamic column names in the dropdown based on the input.