Passing a Text Box variable to a Select Tool

robertfishel

Hello Alteryx fans!  This one seems simple, but so far I have been unable to get it to work.  I am trying to pass the value a user enters in a Text Box tool to a Select Tool so that it can be used later on in my workflow.  Same thing with a Drop Down tool.  I don't see my variable names in my Select Tool field list.  Here is a sample of my workflow.  Thank you!

ChrisHe

Hey @robertfishel,

This is definitely a common thing I see people trying to accomplish in Alteryx and it's a little bit more complicated than you  might expect.  For the Text Box option, the only thing you'd need to change is swapping out the Select Tool for a Dynamic Select.  I've attached a sample workflow for that here.

For the dropdown, there are a couple of other things to consider as the Drop-Down would need to read the metadata of the fields at runtime in order to display them for an end user to pick.  If the purpose of your app includes someone selecting their own file to input, then you can have the drop-down be fed fields directly from that File Browse interface tool (I've also attached an example of this).

If the fields aren't being generated from a user-inputted file then your main option is to create a chained app, where the first writes the file names to a file and then the second uses that file and will therefore have the field names at run time.  The options for doing that have been covered in this thread here.

Hope this is helpful!

Best,

Chris

Text box to select.yxwz

drop down to select.yxwz