Manual input variable and feeding down to data input

[siuki91]

Hi Community,

Kindly need your assistance here as I am beginner of the Alteryx Designer tool.

I have one set of data A as shown in the below and i would like to add in one column such as FX Rate (manually input from the Text box feature or another feature option), and the manual input FX rate variable feed down to the data output.

May I ask is there any possible way to achieve this?

many thanks.

[Qiu]

@siuki91 
Maybe a text input tool is better than a formula tool? 😀

[danilang]

Hi @siuki91 

When you connect an interface tool to the Q(uestion) input of a tool, the input from the interface tool becomes a variable that's available for use in the connected tool.  

In the formula, you have to reference this value.  The formula in the attached workflow is 

if isempty([#1]) then 
	1
else
	tonumber([#1])
endif

The value from the interface tool is called the same as the name that shows up on the connection, [#1] in this case.   If you have multiple interface tools connected to the same tool each connection will get it own number.   You'll notice in the formula, that there is a check for IsEmpty([#1]).  This is because it's possible for the value to be blank in which I just used 1.  Without this any.   Values from interface tools are always strings, so you have to explicitly convert them to a different datatype if required.

Dan