Discussion Board for collaboration on QlikView Scripting.
Below is a query where I used Lookup (despite warnings) to find the first value from the field FName.
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?
Go to Solution.
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)
Good suggestion. It turned out to be very much faster. A blink compared to seconds. Thanks!