We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

incorporating a Join tool into a macro interface

ckelley0
8 - Asteroid

I am building a workflow that compares two tables.  I need the macro interface to allow the user to configure a join tool.  

2 REPLIES 2
FinnCharlton
13 - Pulsar

Hi @ckelley0 , you can allow the user to configure a join tool by using an Action tool:

FinnCharlton_0-1676903543333.png

With this, multiple parts of the configuration can be updated, including the fields used to join and the fields selected after the join. Add an interface tool, like a drop down or text box, to this action tool to allow the user to change the configuration. 

 

If you need any more specific help with what you're trying to do let me know

ckelley0
8 - Asteroid

I am trying to create a macro interface that would allow the user to join on any fieldname, any field datatype and be any number of fields. It's this last requirement that I am having trouble overcoming.  It looks like each join needs a pair of tools, two drop down interface tools and two action tools, for each join. One solution would be to include ten or some sufficiently large number of joins with the hope that your users will not need more, but ideally the macro would be able to join an x number of fields.  Attached is an example of a macro that has one field to join on. 

Labels
Top Solution Authors