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.
Solved! Go to Solution.
@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.
@apathetichell example provided does exactly that 😊
@ppatane updated the workflow to dynamically load the user name from the input file
@binuacs quite complex (to me), but awesome result!
User | Count |
---|---|
38 | |
32 | |
8 | |
7 | |
7 |