Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
SOLVED

Select List After a DETOUR is Empty

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Ok, I've got a suggested workflow here, and it's definitely a detour from the Detour tools.

 

Let's start with the user interface. Since only one field can be selected at a time, this could be accomplished by either a set of Radio Buttons, or a Dropdown. I decided to use a Dropdown for two reasons

1) It allows the field list to be dynamic (instead of setting a Radio Button for each). This list can be updated dynamically to list all fields connected to the input of the Dropdown tool. 

2) it means we only need one "Search Value" field, which makes updating the filter much easier.

 

Detours... because the filter tool can have both the field and value searched changed, one filter tools can perform all the filtering/detouring we need. There are two Action tools attached to the Filter tool: one to update the field that is searched, and another to update the value that is searched in that field.

 

Next, since it looks like your were performing the same formatting on the field values each time: instead of using the same set of tools copied for each detour, let's just have one set of tools so any changes to this process only has to be done once.

 

Finally, I added a section after your formatting to make sure there's an output for the user to see when there are no search results. This may not be necessary in your case, but it's a part of the user experience to consider when building applications. 

 

20200212-DetourDetour.png

 

 

 

 

 

 

 

Take a look at the attached App and let me know what you think. 

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Wow, look at the similarities in the solutions that @danilang and I independently provided. Nice work!

Highlighted
7 - Meteor

Brilliant! Thanks so much Charlie for investing the time in this. I literally spent the entire day today trying to get all the detours to play together. I finally ended up substituting a dynamic query and almost got to home plate but still had issues getting the select tool to work after the dynamic query. Anyway, this is a lifesaver. Thanks again. Art

Highlighted
7 - Meteor

Thanks so much danilang! I replied earlier that this was a perfect solution.  I have one follow up question. Is it possible to output the selection actually made by the user (e.g., account, lastname, email or loginid) and pass it down the workflow? I may need to query what they selected and branch the final output files based on that.

Highlighted
17 - Castor
17 - Castor

Hi @artzee1556 

 

I made a change adding a formula tool that creates a new field called [Selection] and linked that to the Drop Down.  Now the value of [Selection] is the Field name you selected in the UI and is available further downstream.

 

w2.png

 

BTW.  It is possible to mark more than one answer as a solution.  @CharlieS 

 

Dan

Labels