community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Add another option for "data from connected tool" for drop down and list box

The drop down\list box have numerous ways to list values. One of them that I like is connecting to an external source. You simply have an external source file with a Name column and a Value column. It will display the data in the Name column and pass the data in the Value column. Now suppose instead of connecting to an external source I wanted to use connected tools. Currently, I would have to crosstab this data and the drop down\list box would display and pass the column names.

 

What if the drop down\list box could have an additional option added where you could connect tools and it would act identically as an external source (display the data in the Name column and pass the data in the Value column). This would be much easier and more functional!

3 Comments
Alteryx
Alteryx
Status changed to: Comments Requested

Thanks for the idea! Can you tell about a scenario or example where you would use this functionality? I'm trying to understand the problem you are trying to solve when you'd use a solution like this. 

Suppose I have a list of cities and their corresponding codes so that the user can pick a city. This selection is then used to query our data to get the list of counties for that city. Here is what I would do today:

Capture.PNG

 

Here is what I don't like:

1) I had to crosstab the the data. Why should that be required?

2) Because of #1, I now have to replace the underscores with spaces. If I had a different dataset, this would be more complicated because all special characters are being changed to underscores. This time it's easier since it's just spaces, but any dataset with special characters would require even more effort to fix our list.

3) Once I get the user selection, I have to go back to my first table and grab the city code. I like how the drop down normally lets you display one thing to the user (the city name) and pass another to your workflow (the city code). This functionality is lost when I use the connected tool setup. 

 

Here is my mockup of my request:

Capture.PNG
It's simpler and more straightforward. You give the dropdown your list to display, and then pass the answer (the city code instead of the city name) to your filter. It eliminates all 3 of my complaints above. For the dropdown, I'm imagining a prettier version of this:

Capture.PNG

 

Asteroid

I second this request -- this would be incredibly valuable to me as well.