Alteryx Interface HELP

Hello,

I am new to alteryx interface tools. I am trying to see if there is any way I can filter one specific entity and modify the FTI and bonus amount depending on my needs. For Example, lets say I want A and C to stay the same and I want add 100 dollars more in both Bonus and FTI for B. Is there any way I can build an action tool that will allow me to do that? Thanks in advance

Developer

Developer Tools

Apps

Interface Tools

Accepted answers

RolandSchubert

Hi @rrahu07 ,

if I got you right, you try to select the entity using an interface tool (e.g. Drop Down) and enter an amount for change:

Could this be an approach to solve your problem - what do you think?

Best,

Roland

InterfaceTools.yxwz

RolandSchubert

Hi @rrahu07 ,

you've been very close to the solution, you only missed to enter the string to replace in the first Action tool, add the existing entry in the condition (A) and it should work.

You could simplify it a bit. You use a Drop Down tool to select the entity and Text Box tools to enter the values. In the Action tool, you can change only the "variable part" of the condition or the formula using "Replace a specific string" (for [Entity ID] = "A" only the A and for [FTI]+1000 only the 1000). Doing so, data entry is easier. (I tried to explain the process in the picture)