Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
Good suggestion. It turned out to be very much faster. A blink compared to seconds. Thanks!