topic Allocating data input fields to variables set up in the formula tool in Alteryx Designer Desktop Discussions

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

Alex_H — Thu, 13 Jun 2024 21:51:12 GMT

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

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

Alex_H — Fri, 15 Jul 2022 09:47:35 GMT

anyone able to help?

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

FláviaB — Fri, 15 Jul 2022 18:12:23 GMT

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.

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

CathyS_Slalom — Fri, 15 Jul 2022 19:39:43 GMT

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

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

Alex_H — Mon, 18 Jul 2022 09:17:09 GMT

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

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

Alex_H — Mon, 18 Jul 2022 09:22:45 GMT

Thanks very much, i will try this out

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

FláviaB — Mon, 18 Jul 2022 15:15:15 GMT

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. 😉