Qlik Community

Ask a Question

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
bill_markham

Performance: ApplyMap in Preceding Map

Hi

I have noticed that this script runs about 4 times slower than the script at the bottom :

Load

ApplyMap ( 'MapSicknessHours' , [SCD Environment Date Employee Key] , 0 ) as [Sickness Hours] ,

*

;

Load

  [SCD Environment] & '|' &  [Date] & '|' &  [SCD Employee Number] as [SCD Environment Date Employee Key]  ,

  *

resident Temp10

;

Whereas eliminating the Preceding Load is 4 times faster :

Load

  ApplyMap ( 'MapSicknessHours' , [SCD Environment] & '|' &  [Date] & '|' &  [SCD Employee Number] , 0 ) as [Sickness Hours]
resident Temp10
 

;

I am curious as to why is the case.  Any ideas anybody ?

Normally I love preceding loads, but not in this case.

Best Regards,     Bill

1 Reply
rwunderlich

Hi Bill,

The two scripts are not comparable.  In the preceding load, you are keeping the additional field "SCD Environment Date Employee Key".  It's a large string field, so could have significant impact on performance. An interesting comparison would be to not use * on the top load, but list the fields and don't keep "SCD Environment Date Employee Key".

In any case, I don't recommend using Preceding load in this scenario (adding one field). There is no benefit.

-Rob