Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
arsenal1983
Creator
Creator

Apply Map

Hello,

Is the ApplyMap function in the script OPTIMISED or NOT.

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

1 Solution

Accepted Solutions
sunny_talwar

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);

Capture.PNG

View solution in original post

5 Replies
sunny_talwar

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

vinieme12
Champion III
Champion III

ApplyMap() is a script function,

Don't join - use Applymap instead

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
sunny_talwar

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);

Capture.PNG

arsenal1983
Creator
Creator
Author

Have the same result. I thought I did something wrong

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

sunny_talwar

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