How to get Altyerx to pick up a specific cell located in different file in the formular

[Sophia_Xiao]

I have a table A sitting in a file and trying to Alteryx to create a new column named as discount by apply a discount rate 10% to the sales column. The discount rate is sitting in a sperate file in a fixed cell eg "A1". In this file, only have discount rate, no category or sales information in Table A. is it something Altyerx can help 

Table A

Category	Sales
Apple	100
Orange	80

[KGT]

You will need to connect the other sheet as another connection. If it is just what you say, then make sure that the option for headers is correct in the Input tool.

Then an append, followed by a formula tool.

[jirikrecek · Accepted solution]

Attached is a sample of what you want.
I left your discount rate as a decimal instead of 10% text, to make it easier, but if your discount rate is a text, just add an extra formula tool to convert it to a Double (10% >>>>> 0.1).
Select ensures the value is a number and not text - ALWAYS do a select tool after reading any data - to ensure your data types are right
Append adds the discount rate column
Filter - removes null rows - Append tool will double your number of records, so you need to remove them
Formula - does the actual calculation, multiplying the sale price by the discount and then subtracting it from the sale price

Do the filter before the formula, so your formula doesn't have to calculate twice as many rows