How to create table that populates one column's value based on another value?

[TeslaBoy]

Hello! New here. I'm trying to create a table based on two separate tables.

I've pulled in the two tables in B2 & G2 (User_table & rating_multiplier) into Alteryx. The resulting table I want to create is in B10. But each user should have a separate row for the different multiplier types (red, green, blue). The resulting table would then have 3 rows per user.

Having a few issues with this. 1) the user's rating (column D) needs to be measured between the rating_min & rating_max columns in the rating_multiplier table to retrieve the appropriate value. The values are not always even numbers. I'm not sure how to use this column value in reference to another table. Also, in my example here the multiplier column names are not quite the same as the multiplier column names in the B10 table, but they could be changed to be the same.

2) Not sure how to create the resulting table, would this be a union?

If anyone can point me in the right direction I'd appreciate it!!

[binuacs · Accepted solution]

@TeslaBoy based on my understanding i created a workflow 

[TeslaBoy]

Thank you binuacs!