topic Re: Apply Map in QlikView

Apply Map

arsenal1983 — Thu, 08 Dec 2016 10:52:45 GMT

Hello,

Is the ApplyMap function in the script OPTIMISED or NOT.

I mean if script with ApplyMap function is OPTIMISED or NOT.

Re: Apply Map

sunny_talwar — Thu, 08 Dec 2016 11:02:15 GMT

If you are asking that if a qvd load will be optimized if you have used apply map in it? Then I would think it won't... but let's test it out

Re: Apply Map

vinieme12 — Thu, 08 Dec 2016 11:02:40 GMT

ApplyMap() is a script function,

Don't join - use Applymap instead

Re: Apply Map

sunny_talwar — Thu, 08 Dec 2016 11:05:18 GMT

Seems to be not optimized

Table:

LOAD * Inline [

Month

Jan

Feb

];

STORE Table into Table.qvd (qvd);

DROP Table Table;

MappingLoad:

Mapping

LOAD * Inline [

Month, Num

Jan, 1

Feb, 2

];

Table:

LOAD Month,

ApplyMap('MappingLoad', Month) as MonthNum

from Table.qvd (qvd);

Re: Apply Map

arsenal1983 — Thu, 08 Dec 2016 11:47:58 GMT

Have the same result. I thought I did something wrong

I was sure that using ApplyMap will keep the script <optimised>

Re: Apply Map

sunny_talwar — Thu, 08 Dec 2016 12:03:13 GMT

I guess the problem is that anytime you create a new field or do a manipulation to a field, the load will not be an optimized load. I guess use ApplyMap before you create the Qvd