Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

'Tis the season to be spooky! Read our new blog, How Spooky is Your City? Mapping and Predicting Scary Stuff. In it, @SusanCS provides a fun glimpse into using data to figure out the creepy quotient of where you live! And don't forget to check out our Digital Costume Thread to get yourself in the mood for a candy binge!

Add Ability to Reorder Fields Being Joined in Join Tool

I think it would be nice to be able to more easily reorder fields that you're joining by in the Join tool.

 

Capture.PNG

 

For example, I have already joined by CASS_Address and CASS_City. After I did this, I realized I wanted to go back and join on Name, too, and I want that to be first. How the tool is configured now, if I want Name to be first, I must redo all of the drop downs. I would like to be able to add Name to the next set of open drop downs then use some arrow buttons to be able to move them up in the order (similar to the Summarize tool).

4 Comments
11 - Bolide

I'll add that the value of wanting a certain order for join fields is that this order controls the sort order for the data coming out of the J output. So if you just need the J-output, you can sometimes avoid adding an extra sort tool afterwards by setting the sort order in the Join.

 

What would also be nice is for the Right drop down to automatically change if (a) the Left drop down is changed and (b) the Right contains the exact same field name. Currently, the Right drop downs only automatically populates with a field name matching the Left selection when you first fill out the Left drop down, but not when you change the Left selection.

Moira

Awesome additions @DultonM! I agree with everything you said and would love to see those enhancements as well!

Moira

Note the Sort tool has a similar functionality to what we'd like here. If I wanted to add Field2 just after Field1, I could do so by adding it to the bottom then using the arrows to move it above Field3 and Field4. In the Sort tool, I don't have to select Field2 from the second drop down then re-select everything that I want after it, as I do in the Join tool currently. 

 

Capture.PNG

 

The second problem @DultonM brought up is showcased in this example. If I want to add Field2 as the second field, I would have to re-select not only the left fields below it but also the right fields because Alteryx doesn't currently pick up these changes on the right side in the Join tool.

The Hades Ferryman
Status changed to: Not Planned

Thank you for your feedback and idea!

 

Our product team is currently working to properly evaluate and align tool updates and feature enhancement requests alongside out larger initiatives. Due to this we're unable to include this enhancement on a near future road map. To reflect this, I'm updating this idea to Not Planned. However, should this change or we be able to include this idea in a future road map, we will update this idea back to Under Review.