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

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

Topic of Interest

Accepted answers

CathyS_Slalom

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

All comments

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

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 very much, i will try this out

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335