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

[riku_okawa]

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 value	post value
5,000
900
300
3,890
598
199
800
1,600
1,200

Figure2

Min	Max	value
1	99	99
100	100	100
101	108	108
109	118	118
119	128	128
129	138	138
139	148	148
149	158	158
…	…	…

[Jonathan-Sherman · Accepted solution]

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 solution]

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

[riku_okawa]

Thank you very much, I didn't know much about the Generate Rows feature, so it is very helpful!!

[riku_okawa]

Thank you. I followed the method you showed me and am able to do the calculation successfully. Thank you for attaching the workflow as well.