community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
Alteryx Gallery is experiencing a problem in which system emails are not being sent out. As a result, if you are attempting to sign up for a new account, you may be unable to verify your email address. We are working to solve this as soon as possible and will remove this notice once resolved.
SOLVED

Macro Input Tool - More Dynamic Method than Text Input or File Input

Meteoroid

I am trying to figure out the best way to read data into a macro.  Text input is easy and seems to work well, but do I really have to update this each time the data changes?  If I use file input, does this disregard any tools in the main workflow after the Input Data tool?

Alteryx Certified Partner
Alteryx Certified Partner

Hi @sducey95 

 

The key is to only use fields you need in your macro as a Macro Input.

 

Then you can set the option "Show Field Map", so you can use any kind of Input and just pass the fields you need for your Macro at that step of the workflow. 

 

Remember to keep datatypes exactly the same (between Macro Input and your actual Input), otherwise you will run into errors.


Cheers,

Meteoroid

Hi @Thableau,

 

Thank you for your prompt response.  Where exactly does "Show Field Map" appear when checked? And you're saying that by checking this and using a File Input method, I won't have to update the macro each time the core data changes within the file?

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

@sducey95 

 

Below "Anchor Abbreviation".

 

Show Field Map.PNG

 

Then you can use either a File Input or Text Input, as long as you leave only the desired columns for your Macro.

Don't overload the Macro Input with unnecessary fields, see what I mean?

 

Cheers,

Labels