Looking for design suggestions
Posted: Sun May 24, 2020 8:23 am
I have an input link, Link1, that has two values coming in such as:
Val1 Val2
10 20
90 100
200 100000
etc.
There are some situations where Val2 might have a value of 100000.
From Link2, I have values coming in ranges such as:
ValX ValY ValCol
30 40 A
70 80 B
110 120 C
150 160 D
250 300 E
etc.
If Val2 <> 100000 then I need to use Val2 to find the next higher range of ValX and ValY to get the corresponding ValCol value. So for Val1/Val2 value of 10,20, the ValCol value to find would be A. For Val1/Val2 of 90,100 the ValCol value to find would be C and so on. If Val2 is 100000 then I need to use Val1 to find the next higher range which would be 250,300 and the corresponding ValCol to find would be E.
Any ideas how I can implement this?
Val1 Val2
10 20
90 100
200 100000
etc.
There are some situations where Val2 might have a value of 100000.
From Link2, I have values coming in ranges such as:
ValX ValY ValCol
30 40 A
70 80 B
110 120 C
150 160 D
250 300 E
etc.
If Val2 <> 100000 then I need to use Val2 to find the next higher range of ValX and ValY to get the corresponding ValCol value. So for Val1/Val2 value of 10,20, the ValCol value to find would be A. For Val1/Val2 of 90,100 the ValCol value to find would be C and so on. If Val2 is 100000 then I need to use Val1 to find the next higher range which would be 250,300 and the corresponding ValCol to find would be E.
Any ideas how I can implement this?