Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hallo,
I hope sombody can help me with my problem.
I have some Provider-tables, which don't have the same gradation (weight).
Example:
DHL:
Provider weight until(kg) price
DHL 0,5 3,25
DHL 1 4,25
DHL 1,5 6,3
DHL 2 10,20
Etc. in 0,5 steps
Fedex:
Provider weight until(kg) price
FEDEX 1 4,25
FEDEX 2 7,25
FEDEX 3 9,3
FEDEX 4 15,20
Etc in 1kg steps
TNT:
Provider weight until (kg) price
TNT 2 4,25
TNT 4 7,25
TNT 6 9,3
TNT 8 15,20
in 2kg steps
If I search now for a weight of 0,5kg, in the tables, it will only be found in the DHL-Table. In the Fedex Table the value that should be found is (upto) 1kg.
While reading FEDEX the following table should be loaded:
Provider weight until price
FEDEX 0.5 4,25
FEDEX 1 4,25
FEDEX 1,5 4,25
FEDEX 2 7,25
FEDEX 2,5 7,25
FEDEX 3 9,3
FEDEX 3,5 9,3
FEDEX 4 15,20
FEDEX 4,5 15,20
While reading TNT the following table should be loaded:
Provider weight until price
TNT 0,5 4,25
TNT 1 4,25
TNT 1,5 4,25
TNT 2 4,25
TNT 2,5 7,25
TNT 3 7,25
TNT 3,5 7,25
TNT 4 7,25
TNT 4,5 9,3
TNT 5 9,3
TNT 5,5 9,3
TNT 6 9,3
Would be very nice if somebody can help me .
Thanks in advance
Marcus
Look into using IntervalMatch(). F1 help is pretty good or there are good examples of use in this forum.
Hope this helps,
Jason
Maybe you should use IntervalMatch.
Another aproach could be generate a temp table like below
Weight:
LOAD
RowNo() / 2 as weight
AutoGenerate 20;
Then use this table "left joined" with your ProviderTable