I am trying to achieve something which i think should be done by Mapping Load,Below is my code
Delivery :
LOAD
DELIVERY_KEY,
DELIVERY_DESC,
CALENDAR_MO_ID ;
SQL SELECT *
FROM master.test;
STORE Delivery INTO Datasources\Delivery.qvd (qvd) ;
DeliveryNumber:
MAPPING LOAD DISTINCT
DELIVERY_KEY ;
FROM Delivery.qvd;
What i am trying to achieve is I want to name Delivery_key as DeliveryNumber and when i hit a reload i must be able to see these 2 fileds showing up.If i remember correctly this can be achieved by Mapping load,But i amtrying it to no luc.Can some one please correct me where i went worng?or please also let me know if what i am trying to achieve is also not correct and if there is anyother way to do this?
There are probably a lot more useful blog posts, forum threads (and not to forget the HELP and ref manual itself).
If you could describe a bit closer what you want to achieve (I must admit I haven't fully understood), I am sure someone around can help you with the exact syntax.
As far as I can see, you are trying to build a mapping table using a MAPPING LOAD, but a mapping table must show exactely two fields. First field keeps the value you want to match with your input, second the value you want to use instead.
You can then use this mapping table using an applymap() or mapsubstring() function call or MAP ... USING statement.
