So, I am trying to tell alteryx to perform a calculation on a column to the left a column. The reason is because the column I have does not have a title but the column on the right of it does. Hence, I need to ask Alteryx to keep the column on the left of the column I reference, see below.
Input
| Name | | 2020 | | | Number of fruits | |
| Orange | other data | other data | other data | 50 | 1 | |
| Grape | other data | other data | other data | 10 | 2 | |
| Pear | other data | other data | other data | 20 | 3 | |
| Strawberry | other data | other data | other data | 30 | 4 | |
Output
| Name | Weight |
| Orange | 50 |
| Grape | 10 |
| Pear | 20 |
| Strawberry | 30 |
The number of columns between "Name" and "Number of Fruits" will vary between tabs, but the one thing that stays the same is that I need to reference the column to the left of the column titled "Number of Fruits" and keep that column. I cannot simply use a static reference because the position of the column to the left of the column titled "Number of Fruits" will change but it will be the column to the left every time.
How can I tell the program to do this? Trying to do this without a Macro, any advice would be appreciated.
