How to use a separate control sheet for thresholds?

johny9887

Hi,

I have a question about the following:

Currently I have the Actual Data file which has the Location number, date, KPI1/KPI2 information. I want to be able to create new columns based on the KPI columns using the thresholds:

- Ex - KPI1: I have the following conditions

                      - IF KPI1 >=0 and KPI1 <=3 then 1

                      - IF KPI1 > 3 and KPI1 <=6 then 3

                      - IF KPI1 >6 then 5

I have already hard coded in as formula in alteryx but I was wondering if there was a way to instead bring in a separate file dedicated for thresholds (attached as "threshold try" file) where I can simply use the thresholds in this file to create the new column instead of hardcoding the thresholds 0, 3, 6 like in the example above.

The end result I want will look like this for example 

Thank you

Actual data.xlsx

threshold try.xlsx

michelle_mathews

Hi @johny9887 , you can bring the threshold data in as a separate input (though I'd recommend pivoting the data to be on one row). You can then append that to your Actual data file and reference the threshold columns in your formula instead of hardcoding the numbers.