topic Re: mapping Load in QlikView

mapping Load

Mon, 06 May 2013 20:26:00 GMT

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?

Thanks,

Sujith.

Re: mapping Load

swuehl — Mon, 06 May 2013 21:43:22 GMT

Please check these blog posts for an introduction to a mapping load / applymap() :

http://qlikshare.com/194

http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/

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.

Hope this helps,

Stefan

Re: mapping Load

Tue, 07 May 2013 15:34:01 GMT

Hi Swuehl,

Thanks for your help.It did help me a lot.

Thanks,

Sujith.