Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
yu should use mapping keyword na
Pickup_Mapping:
Mapping LOAD OUTLET_ID & '-' & PICKUP_ID as OutletPickup,
PickupOutlets.OUTLET_NAME
FROM
[someqvd.qvd]
(qvd);
yu should use mapping keyword na
Pickup_Mapping:
Mapping LOAD OUTLET_ID & '-' & PICKUP_ID as OutletPickup,
PickupOutlets.OUTLET_NAME
FROM
[someqvd.qvd]
(qvd);
Pickup_Mapping:
MAPPING LOAD OUTLET_ID & '-' & PICKUP_ID as OutletPickup,
PickupOutlets.OUTLET_NAME
FROM
[someqvd.qvd]
(qvd);
Of course,
how could I not see this. Thank you very much.