Suggested Associations in the Join tool (And related tools)

[mceleavey]

Hi All,

I think this suggestion would be be ideal for the Join tool and it's related cousins (Join Multiple etc.) and would improve the experience of data blending for all users.

I am going to rely on Qlik Sense for this explanation as this functionality is native to that product.

When we bring in two data sources and use the join tool to blend we are required to select the field or fields upon which we want to base our join.

In Qlik Sense we can see our two data sources:

We can then drag them together and it will form suggestions based on data association density:

This helps with identifying how tables should be joined, and at the very least shows commonalities between data streams, based on the data within the tables and not any naming conventions.

It would be nice to have the functionality to generate suggestions based on association density between two data streams, and then to apply the join from a selection.

 Thoughts?

[SeanAdams]

very clever idea - and fits in well with the idea that the Alteryx team talked about at Inspire where the intent is to allow more and more people to do this job by making it more approachable.

This is not foolproof, but it is a very useful idea and way better than the current approach where users get no hints at all.

[mceleavey]

@SeanAdams thanks.

Yeah, I think with the aim of removing the IT bottleneck, anything that can help with the basic data prep tasks can only be a positive.

[Community_Admin]

The status of this idea has been changed to 'Inactive'. This status indicates that:

1. The idea has not had activity in the form of likes or comments in over a year.

2. The idea has not reached ten likes.

3. The idea is still in the 'New Idea' status. 

However, this doesn't mean your idea won't be implemented! The Community can still like and comment on this idea. With enough renewed interest, this idea can be brought back into the 'New Idea' status. 

Thank you for contributing to the Alteryx Community and the Alteryx Product Idea Boards!