Apply Map

[arsenal1983]

Hello,

Is the ApplyMap function in the script OPTIMISED or NOT.

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

[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]

ApplyMap() is a script function,

Don't join - use Applymap instead

[sunny_talwar · Accepted solution]

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

[arsenal1983]

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