How to reference another table and use the range of the referenced table in the analysis

Question

As shown in Fig. 1 below, I have already given a pre value, and I want to calculate the post value by using Alteryx.
To get the post value, I want to use a table like the one in Figure 2, and use the value of the column when the "pre value" is greater than "min" and less than "max" for each column in Figure 2 as the "post value".
However, I don't know how to do this calculation in alteryx. How can I do this kind of calculation?

Figure1

pre valuepost value5,000　900　300　3,890　598　199　800　1,600　1,200

Figure2

MinMaxvalue19999100100100101108108109118118119128128129138138139148148149158158………

Jonathan-Sherman · Accepted Answer

Hi @riku_okawa,

You can do this kind of calculation by appending the second table to the first and determining which bounds fit the condition. I've used a summarise tool also to check how many bounds each pre-value fits the criteria of (should always be one)

I've attached my workflow for you to download if needed.

Kind regards,

Jonathan

danilang · Accepted Answer

Hi @riku_okawa

Another way to do this is to generate a row for each of the values in your ranges and join this table to the Pre values in your input

Dan