How to get Altyerx to pick up a specific cell located in different file in the formular
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 |
Solved! Go to Solution.
- Labels:
- Help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
