Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

Sophia_Xiao
7 - Meteor

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

CategorySales
Apple100
Orange80

 

 

2 REPLIES 2
KGT
12 - Quasar

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
8 - Asteroid

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

 

Screenshot 2025-02-24 094230.png

Labels
Top Solution Authors