Assign criteria during script load based on conditions

[#1]

Hello,

I have two tables, deliveries and tariffs.

Delivery	KG
123456	12
234567	88
345678	105
456789	69

For the tariffs there exist weight buckets with lower and upper limits. They determine which price is assigned. 

Tariff	LowerLimit	UpperLimit	Price
A	0	20	2
B	21	40	3
C	41	60	4
D	61	100	5
E	100	150	6

In the end I would like to see that each delivery is assigned the correct price:

Delivery	KG	DeliveryPrice
123456	12	2
234567	88	5
345678	105	6
456789	69	5

Best would be to make this assigment during the loading of the script.

(The example is a very simplified version, you can imagine^^)

Can you help me setting this up?

Thanks and Kind regards

Philipp

[vinieme12]

see this post the concept and working remains the same

IntervalMatch

[vinieme12]

Interval Match Feature/Function

Example for IntervalMatch function