Free Trial

Alteryx Designer Desktop Discussions

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

Results based on dropdown

ppatane
8 - Asteroid

I want to be able to select an individual from a drop-down list and receive back a list of their projects.  I'd tried the Join tool to no avail, so I am tring this workaround, which to me, is logical, but I get no results. If I remove the filter tool, I get the expected results of the user selected on every line next to the name and value fields.(1st screenshot)  When I add a simple filter, I get nothing back. (2nd screenshot)  I'm sure there is a simple solution that I am not seeing.

 

3.jpg

 

1.jpg2.jpg

5 REPLIES 5
alexnajm
18 - Pollux
18 - Pollux

I think you may be overcomplicating it - why can't the users just directly affect the filter?

apathetichell
19 - Altair

@ppatane ---> use a filter in custom mode. [User]in("Perez, Manuel') ---> configure listbox in list mode -->
delimit to look like " "," "

use action tool in update value. put "Perez, Manuel" in replace specific string---> include quotes.. click box.. run via wand.

alexnajm
18 - Pollux
18 - Pollux

@apathetichell example provided does exactly that 😊

binuacs
21 - Polaris

@ppatane updated the workflow to dynamically load the user name from the input file

image.png

ppatane
8 - Asteroid

@binuacs quite complex (to me), but awesome result!

Labels
Top Solution Authors