This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
I have macro where show the ‘Show field map’ is checked. I want to create where where only some of the field are mapped instead of all the fields. Is this possible in the macro or some other custom tool?
If you manually add a dropdown interface which takes as its values the fields from the macro input, you can allow [none] as an option. From there, you could use a Summarize tool to identify fields with no values populated, and use that to drive a Select tool to remove the fields from the output.
When you allow the Macro to show the field map, it will require you to match every single field, not just the ones you need.
I built a macro like this, and I use it every day. Keep meaning to post it to the gallery, so I'll post a link when I do.
EDIT: Here it is. It's a bit of work to add new 'standard' fields, but once you do, it works nicely. Hope you find it useful.