Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

christianlaurit
Not applicable

Lookup - performance killer

Below is a query where I used Lookup (despite warnings) to find the first value from the field FName.

LOAD      O_orgno,

               O_name,

                ApplyMap('Company_OrgnoChange',F_orgno) as F_orgno,

                ApplyMap('Company_NameChange',F_orgno,Lookup('FName','FOrg',F_orgno,'tmpLookup')) as F_name

Resident Final1 where isnull (KeepNames) and F_orgno <> '#Missing#';

And yes, it is SLOW... very much so.

How could I rewrite the load statement so it is fast, I guess not using Lookup?

Tags (2)
1 Solution

Accepted Solutions
jontydkpi
Not applicable

Re: Lookup - performance killer

Hi

You could try nested ApplyMaps rather than a Lookup, something like:

     ApplyMap('Map1', [Field1], ApplyMap('Map2', [Field2], 'Default'))

(Just guessing, as you have not provided any details what you are trying achieve with the lookup)

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
2 Replies
jontydkpi
Not applicable

Re: Lookup - performance killer

Hi

You could try nested ApplyMaps rather than a Lookup, something like:

     ApplyMap('Map1', [Field1], ApplyMap('Map2', [Field2], 'Default'))

(Just guessing, as you have not provided any details what you are trying achieve with the lookup)

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
christianlaurit
Not applicable

Re: Lookup - performance killer

Good suggestion. It turned out to be very much faster. A blink compared to seconds. Thanks!