Allocating data input fields to variables set up in the formula tool

[Alex_H]

In my Alteryx workflow, i'd really like to have a data input, followed by a field selection, and then set up some variables which can then be easily assigned fields from the data input.. currently my workflow is like this...

Data Input, data cleanse, field selection, then the formula tool to add create the variable to use downstream.

Does anyone have any suggestions please on how can I then assign input values to those variables, but using a drop down list, rather than having to manually type them in under each variable name within the formula tool?  is there a way I can achieve that and help make the user experience better?

Thank you

Alex

[Alex_H]

anyone able to help?

[FláviaB]

Hey @Alex_H. Thank you for your post. It might be because the Introduce Yourself board is not the best place to ask technical questions. 😉 I am moving you post to our Designer Discussions board for more visibility. Moving forward, feel free to start a new thread in there if you have any other questions.  

[CathyS_Slalom · Accepted solution]

Hi @Alex_H, you can click the X from formula configuration to select the columns that you want to use instead of type it.

[Alex_H]

Thanks, sorry it was my first post and didnt realise wrong board, thanks for help getting my question noticed

[Alex_H]

Thanks very much, i will try this out

[FláviaB]

No worries, @Alex_H. I am glad you already have someone helping with some suggestions. In fact, if this helps to solve your problem, don't forget to mark the answer as solution so you can also help other users to find this answer easier. 😉