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 INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
1 Day Left! - The Alteryx Community will be temporarily unavailable for a few hours due to implementation of the new SSO experience starting tomorrow at 5pm MDT. Please plan accordingly. For more information, read the blog.
I would like to create a listbox that allows a user to select which columns they would like a multifield formula tool to apply to.
I have been able to do this successfully, however as the next step, I am hoping to make this listbox dynamic, so that it will take the field names from an input data set (or tool connection), rather than from the macro templated input.
Example would be having a file input with the fields 1, 2 and 3, and have these appear in the macro as the list box selections.
Then, in a separate workflow, I would connect a different data set to the macro which might have the fields 4, 5, 6, 7 and 8, and for the list box to update itself to have these fields as the selection options.
I'm pretty sure this can be done within an analytic app, but this needs to be a macro and I'm wondering if this can be done.
As a leader in the Alteryx Community, I have the ability to identify & mark accepted solutions on behalf of community members - and recently did so on this thread. If you have any questions or concerns with the solution(s) I selected please let me know by replying to this post.
Good job finding the solution. Interface tools are tricky. BTW...In case where you've done the work to discover the solution yourself, it's acceptable to mark your own response as the solution.