Qlikview load (intermediate values)

[#1]

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

[Jason_Michaelides]

Look into using IntervalMatch().  F1 help is pretty good or there are good examples of use in this forum.

Hope this helps,

Jason

[Clever_Anjos]

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