ApplyMap does not return results

[#1]

Hi everybody,

I am sure that this should be an easy task but for some reason I have troubles to find my error. I want to use a simple ApplyMap function. My code looks like this:

Pickup_Mapping:

LOAD OUTLET_ID & '-' &  PICKUP_ID as OutletPickup,

     PickupOutlets.OUTLET_NAME

FROM

[someqvd.qvd]

(qvd);

StateTimes:

LOAD

     SomeColumns1,

     SomeColumns2,

     OUTLET_ID & '-' & PICKUP_ID as OutletPickup,

     ApplyMap('Pickup_Mapping', OUTLET_ID & '-' & PICKUP_ID) as OUTLET_NAME

FROM

[someotherqvd.qvd]

(qvd);

My Problem is now, that the result of ApplyMap is null for each row, although there should be a match for almost each row. If I look in my table view, the two tables are connected and have a 100% information density and a 92% subset ratio. If I select PickupOutlets.OUTLET_NAME the right filters apply on the data from other tables.

I do not find the problem in my code and I really appreciate your help on this one.

Cheers,

Claus

[gautik92 · Accepted solution]

yu should use mapping keyword na

Pickup_Mapping:

Mapping LOAD OUTLET_ID & '-' &  PICKUP_ID as OutletPickup,

     PickupOutlets.OUTLET_NAME

FROM

[someqvd.qvd]

(qvd);

[Clever_Anjos]

Pickup_Mapping:

MAPPING LOAD OUTLET_ID & '-' &  PICKUP_ID as OutletPickup,

     PickupOutlets.OUTLET_NAME

FROM

[someqvd.qvd]

(qvd);

[#4]

Of course,

how could I not see this. Thank you very much.